Subreports duplicating in main report

[Guest]

When I have a sub report in this report I'm working on, it insists on
displaying four times.The exact same thing 4 times. The subreport does not do
this when ran separately. Any suggestions?

 

[Guest]

Closer analysis reveals... it's the Details section thats repeating multiple
times.

Any thoughts? I've never seen this before.

 

[Duane Hookom]

Remove a level of detail records from your main report's record source.

 

[Guest]

When the report is bound to a table (record source) the details section will
repeat itself as the amount of records in that table.
If you want to add a sub report to the report that suppose to apear only
once, create it in the header or footer section of the report

The sub report wont repeat itself in the details section if there is only
one record in the table that the report is bounded to, or don't bound the
report.

 

[Guest]

When the report is bound to a table (record source) the details section will
repeat itself as the amount of records in that table.
If you want to add a sub report to the report that suppose to apear only
once, create it in the header or footer section of the report

The sub report wont repeat itself in the details section if there is only
one record in the table that the report is bounded to, or don't bound the
report.

I don't understand. Don't link the sub to the main report? But I have to
have a field connecting the child to the master.

And it doesn't seem to be tied to the number of record the sub is selecting.
I ran the master, and the sub pulled 9 records, but it only repeated four
times.

Bound to a table... The sub is based on an SQL statement, not a table. Is
that what you mean?

Please clarify.

~Yb