Multiple Subreport Problem

[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

 

[Muskiefan]

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.

 

[KARL DEWEY]

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?

 

[Ryan]

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

 

[Marshall Barton]

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

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.

 

[KARL DEWEY]

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?

 

[Ryan]

Thanks, I will give that a Try

Ryan

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.

 

[Ryan]

i got it working...thanks for the help

Thanks, I will give that a Try

Ryan