Subreport repeats as many times as there are detail records

[Guest]

I have seen more than one post on this subject but no answer that resolves
problem. I have a main report whose fields are provided by query against main
order which supplies also the related engineer and supplier from the related
one-to-many relationships.

The subreport provides the detail records/lines from the related products
file. However the subreport is repeated completely for each occurance of the
detail records. So 9 products result in 9 subreport prints.

I have checked file relationships and Master/Child relationships and all
seem fine. In an earlier post Doane said remove level from main record source
but can't see anything I can remove as all detail is required to be printed.

Any ideas most welcome.

Many thanks in advance

Nigel

 

[Guest]

This is similar to a problem I had yesterday. One of the sub reports was
based on the same query as the main report, the other sub report was based on
a separate query. When I changed the main report to be based on a query that
returned no values, the sub query that was being repeated only showed up
once.

Hope this works for you.

Karen

 

[Duane Hookom]

Wow! It's great to see you jumping in to help with your "fresh" information.

 

[Guest]

Folks, thanks for your input. I have just tried a different approach which
has now worked. I removed the subreport and replaced it by a detail line
identical to the one in the original subreport. I also added the required
fields to the query that the main report was based on - so effectively I only
had one query rather than two. This resolved the problem.

I guess the problem therefore was that previously there was a query running
within another query - but I am only guessing, and in any case why should
that be a problem when the top level query only returns one record?

Hope this helps someone.

Nigel