How do I fit all my headers into a report?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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


Benjamin said:
Hi,

I used a cross-tab query to pull data and want to print a report based on
Click to expand...
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
Click to expand...
headers on the first page, the next 10 on the second and.... etc?
 
Back
Top