Multiple Subreport Problem

  • Thread starter Thread starter Ryan
  • Start date Start date
R

Ryan

Hello, I have 5 subreports in one report. Each sub report runs off of its
own query which queries based on the field that comes up in the main report.
My problem is that the data repeats itself and what should be a 3 page report
becomes 64 pages of the same thing repeated over and over. Any help would be
appreciated

Ryan
 
On each of your subreports is the data you are displaying in the detail
section? It probably needs to be in a group header based on the link in the
main report. i.e. if the link is CustomerId, on the subreport create a group
header on CustomerId and put the fields in that section.
 
Each sub report runs off of its own query which queries based on the field
that comes up in the main report.
I can understand 'Each sub report runs off of its own query' but not the
latter part of the above statement.

Can you explain?
 
each sub report would run independantly iguess is the best way. Each Query
sorts the data the way I need it and then i want to display it on the main
report. what is happening is that all the reports are running and displaying
the information, but then it will display it all again, and again, and
again...not sure why this is happening?

Ryan
 
Ryan said:
Hello, I have 5 subreports in one report. Each sub report runs off of its
own query which queries based on the field that comes up in the main report.
My problem is that the data repeats itself and what should be a 3 page report
becomes 64 pages of the same thing repeated over and over. Any help would be
appreciated
Click to expand...


A common cause of that problem is when the main report's
record source query includes the same tables that are used
in the subreports.

The main report's record source query should only include
records that are used in the main report and the subreport
**controls** LinkMaster/Child properties take care of
linking the subreports' records to the current main report
record.
 
Each Query sorts the data the way I need it
Any sort in a query is ignored in a report.
This I do not follow. What is the Record Source for the main report?
 
Thanks, I will give that a Try

Ryan

Marshall Barton said:
A common cause of that problem is when the main report's
record source query includes the same tables that are used
in the subreports.

The main report's record source query should only include
records that are used in the main report and the subreport
**controls** LinkMaster/Child properties take care of
linking the subreports' records to the current main report
record.
Click to expand...
 
Back
Top