Dynamic crosstab reports

[Jhuny B]

I have gone through several posts regarding dynamic crosstab reports and I'm
still confused. I have created a crosstab query that provides an overiew of
the quantity of products delivered to departments during a period. The layout
is as follows:
Department 1 Department 2 etc
Product 1 quantity quantity
Product 2 quantity quantity
etc
You can imagine that depending on the period, several departments will not
appear on the list. How do I create a dynamic report without the familiar
error message appearing when the department does not appear in the
query/report?
Thanks a lot in advance for your help.

 

[Al Campagna]

Jhuny,
Trying to describe how to do a dynamic crosstab report is beyond the scope of newsgroup
email communication.
It's a complicated process, but do-able.

Do a normal Google web search on "Micosoft Access" "dynamic crosstab"
You find several tutorials, and more importantly many sample files with code.
Download and study up on several that you find, and pick one that you feel you
understand, and can follow.
Bring that code into your report, and customize it for your particular needs.

It's a great code learning experience, but does require some "sweat equity"...

for example... among others
http://www.blueclaw-db.com/microsoft_access_reports/
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q328320

 

[Duane Hookom]

There are several different solutions depending on your needs. If you always
want every department to display then add all the departments into the
Column Headings property of your crosstab query.

If you only want departments with data to appear then I recommend the
crosstab report solution found at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

 

[Jhuny B]

Dear Al and Duane,
I went through some additional material and was able to get some helpful
information, explanations and codes. Thanks for the advice and links.
Regards,
JB