Results 1 to 4 of 4
  1. #1
    Ken Olson
    Guest

    dynamic crosstab report

    I implemented the Employee Sales dynamic cross tab report in to an application of mine. It works fine except that it is limited on the number of columns. I need it to compute when the number of columns that can fit on page has been hit and then simply put the additional columns on a new page. The report currently does this with the rows, by handling an unlimited number, which I will need it to continue to do.

    I also tried the MS-Knowledgebase article "Q103262 ACC1x: How to Create a Dynamic Crosstab Report" which applies to: Microsoft Access versions 1.0, 1.1
    http://support.microsoft.com/support/kb/ar...G&SA=ALLKB&FR=0
    But I couldn't get the code converted properly to Access 97 format. Not even sure that if I did get the code to work, that it would give me the results I'm looking for.

    Do you know of anyone that has tackled this problem? I've searched several places such as the developers forum on CompuServe, the MS Knowledgebase web, and some sites on the web.

  2. #2
    Lounger
    Join Date
    Apr 2001
    Location
    Khon Kaen, Thailand
    Posts
    43
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: dynamic crosstab report

    If you installed A97, you should find Solution.mdb in the samples folder. The code is working OK in this version.
    I deal with the limited column by sending the data to pre-defined Excel file (format, print area). It works well.

    Tell me if you still need help.

    Tim K.
    Thailand

  3. #3
    Ken Olson
    Guest

    Re: dynamic crosstab report

    Thanks for your reply and suggestion. I had originally looked at the Solution.mdb code to do this, but stopped when I saw that the columns were limited as you also mentioned.

    I got lucky and was able to find exactly what I needed. I way to do UNLIMITED rows and columns in Access, without the need for any other program such as interoperability. He uses crunching numbers in his example. My need was for text values, which turned out perfectly. Don't let the number of columns selection fool you into thinking the columns are limited to only six. This selection simply tells the code how many to show before wrapping to a new section.

    Duane Hookom of Business Results had the answer. His information is shown below. Oddly enough I just went to his site and the sample mdb, in fact all downloads have been removed. So I've attached a copy of his solution.

    Phone: 715-835-8130
    E-Mail: dhookom@invisibleinc.com
    Web: <A target="_blank" HREF=http://www.invisibleinc.com>http://www.invisibleinc.com</A>
    Programmer: Duane Hookom, Eau Claire, Wisconsin

    Enjoy!

    Ken Olson
    kolson@genesisresource.com

  4. #4
    Lounger
    Join Date
    Apr 2001
    Location
    Khon Kaen, Thailand
    Posts
    43
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: dynamic crosstab report

    Thank you, Ken.
    I will study the code.

    Tim K.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •