How do I fit all my headers into a report?

[Benjamin]

Hi,

I used a cross-tab query to pull data and want to print a report based on that cross-tab query. The problem is that the database is very big and the cross-tab query ends up with a lot of headers. When I try to generate a report, there is an error message saying that I need to reduce the number of headers. I'm using Access 97.

Is there anyway I can generate a report to have for example, the first 10 headers on the first page, the next 10 on the second and.... etc?

thanks for the help!

 

[Duane Hookom]

You might want to check out the crosstab reports at
http://www.invisibleinc.com/divFiles.cfm?divDivID=4. The Crosstab.mdb has a
solution that "wraps" extra columns. You define how many columns you want
and they will wrap as many times as necessary to display all your columns.

--
Duane Hookom
MS Access MVP

Hi,

I used a cross-tab query to pull data and want to print a report based on

that cross-tab query. The problem is that the database is very big and the
cross-tab query ends up with a lot of headers. When I try to generate a
report, there is an error message saying that I need to reduce the number of
headers. I'm using Access 97.

Is there anyway I can generate a report to have for example, the first 10

headers on the first page, the next 10 on the second and.... etc?