Report generating multiple pages

  • Thread starter Thread starter Jim
  • Start date Start date
J

Jim

I have created a report based on a table. The required
fields of this table are placed in the report header.
Within the detail section are three subreports, each
based on their own table. The report fits nicely on one
page, however when I preview the report the detail
sections are reproduced five times generating five pages
before the report footer shows. I can't find any setting
in report properties nor header/footer properties which
would cause this.

I'm sure it's something obvious but I be stumped!

Thanks in advance for your help.
 
Jim said:
I have created a report based on a table. The required
fields of this table are placed in the report header.
Within the detail section are three subreports, each
based on their own table. The report fits nicely on one
page, however when I preview the report the detail
sections are reproduced five times generating five pages
before the report footer shows. I can't find any setting
in report properties nor header/footer properties which
would cause this.
Click to expand...


Check the main report's record source table(?), it sounds
like it has five records. That would explain why the report
has five details.
 
Yes, you are correct. Look's like I still have work to
do. I will come back when I know what my question is.

Thanks a bunch.
 
If you base the report on a query you can specify a
parameter. Without knowing anything about your database
my best suggestion is to go to Help. In the Answer Wizard
type "create a query that prompts".
A parameter will let you narrow down (to 1, if needed) the
number of records that will be displayed. If the query
returns only one record, you will see just one report.
 
Back
Top