Reporting Issue

R

requeth

I've created a very simple report. Well, 1/10th of a report. I have a
report, and it has a sub report. The sub report calls from a query and
I've created an excel style report using the report header and the
detail section. The problem is as follows:

Query pulls 15 records.
The report shows 15 records in my grid as it's supposed to.
<Begin Problem>
The report generates 15 copies of my grid.
</Begin Problem>

If I hadd a new record putting my total records to 16, it generates 16
copies of my grid. If I can find out how this works it will be great
in another report I'm planning, but it's death to me right now.

I cant get it to stop duplicating, and I cant find any setting where
I've told it to do so.

Any ideas?
 
M

Marshall Barton

I've created a very simple report. Well, 1/10th of a report. I have a
report, and it has a sub report. The sub report calls from a query and
I've created an excel style report using the report header and the
detail section. The problem is as follows:

Query pulls 15 records.
The report shows 15 records in my grid as it's supposed to.
<Begin Problem>
The report generates 15 copies of my grid.
</Begin Problem>

If I hadd a new record putting my total records to 16, it generates 16
copies of my grid. If I can find out how this works it will be great
in another report I'm planning, but it's death to me right now.
Click to expand...


It sounds like you have the subreport's table included in
the main report's record source query.
 
Top