Multiple Pages For a Single Page Report

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

Guest

I have a report generated, using a graph, that groups together data based on
one field. The database is still in the design and testing phase. There a
10 test records currently logged - and when I preview the report there are 10
pages of the exact same report. If I add another record - an extra sheet of
the report appears with the same date again. Can anyone provide a possible
cause?

Thanks
 
Pin said:
I have a report generated, using a graph, that groups together data
based on one field. The database is still in the design and testing
phase. There a 10 test records currently logged - and when I preview
the report there are 10 pages of the exact same report. If I add
another record - an extra sheet of the report appears with the same
date again. Can anyone provide a possible cause?

Thanks
Click to expand...

Your chart needs a recordsource. Your report likely does not.

This is simnple if you think about it. The detail section of a report is
generated once for every record in the report's underlying recordsource. If
that source has 5 records the detail section is generated 5 times. If it
has 1000 records then it is generated 1000 times.

Your chart either needs to be moved to a section that is generated only once
or you need to remove the recordsource from the report.
 
Thanks Rick

I had the report in the report detail section, not the report header - and
it was repeating for every record in the database.
 
Back
Top