Cross-Tab Query - Report

[Chris]

I have a cross-tab query that works as desired. I can get it to post to a
report. My problem is the report (legal - landscape mode) is limited to 12
items. How can I get the report to go beyond the 12 items? The data in the
cross-tab query will take multiple pages to print all the data. Is there a
way to get the report to pick up with the next "12" items if the cross-tab
has more than 12 items?

I can post a stripped-down version of the database if needed.

 

[Baz]

Creating a dynamic cross-tab report is by no means easy, but it can be done.
Here's Microsoft's take on it:

http://support.microsoft.com/kb/328320/en-us

Other approaches you might consider are:

- use a form in Pivot Table view. These are fiendishly counter-intuitive to
set up, but quite useful once you've got the hang of it. However,
formatting them for printing (headers/footers and the like) is hopeless.
- export the data to Excel and do a pivot table there.

 

[Chris]

Yea, I've considered exporting the data to Excel. But what I'd like is if
the process could take the first 15 column records and print all the pages
for those items and then continue with the next 15 column records.

I've yet to find a way to do it.

 

[Baz]

Have you considered doing it as multiple reports, one which does the 1st 15
column values, another which does the next 15 and so on? Maybe you could
then include them all in a single report as sub-reports?

 

[Duane Hookom]

There is a sample crosstab report at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane which
allows for any number of columns. "extra" columns are wrapped under the first
set of columns. This is much more flexible and efficient than the MS solution.

 

[Baz]

That sound like exactly what the OP needs.

There is a sample crosstab report at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane which
allows for any number of columns. "extra" columns are wrapped under the
first
set of columns. This is much more flexible and efficient than the MS
solution.
--
Duane Hookom
Microsoft Access MVP
If I have helped you, please help me by donating to UCP
http://www.access.hookom.net/UCP/Default.htm

 

[Chris]

Can't access the page.

There is a sample crosstab report at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane which
allows for any number of columns. "extra" columns are wrapped under the first
set of columns. This is much more flexible and efficient than the MS solution.
--
Duane Hookom
Microsoft Access MVP
If I have helped you, please help me by donating to UCP
http://www.access.hookom.net/UCP/Default.htm

 

[Duane Hookom]

Works for me. Maybe try this direct link.
http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='Cross Tab'

 

[Baz]

It works now, I can confirm that it wasn't working yesterday.