Corsstab Report Headings

[Michael Conroy]

I have seventeen regions that represent sales areas around the country. I
have all seventeen regions listed as column headings in the crosstab query so
they show in the order I would like. If one of the regions is "null" the
region does not display in the query, which is great. Because the query is
further filtered by dates, I usually get only nine or ten regions with
numbers in them. Here is the problem: how do I get only those nine or ten
regions to display on a report? If I put a text box in the report for all
seventeen regions, all of them will show up and only nine or ten will have
numbers in them and I will need a piece of paper larger than fourteen inches.
The crosstab seems to have a lot of flexability, but getting that dynamic
information into a static report appears to be difficult. Any help on this
would be greatly appreciated.

 

[Duane Hookom]

I would use the solution found in the Crosstab download sample at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane. This
solution accomodates any number of columns.

 

[Michael Conroy]

Thanks, Duane, I will look into alias headings. I was hoping for some way to
allow columns/headings to shrink, like detail area can, but I guess that
feature is not there yet.