dynamic crosstab report

Topic

New Reply

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.

Reply | Quote

Replies

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

Reply | Quote

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: http://www.invisibleinc.com
Programmer: Duane Hookom, Eau Claire, Wisconsin

Enjoy!

Ken Olson
kolson@genesisresource.com

Reply | Quote

Thank you, Ken.
I will study the code.

Tim K.

Reply | Quote