How do I stop duplication of records/pages using a subreport in a report?

By jbutka ·
A report was created with a subreport. The subreport was based on a maketable (44 entries). The results were the report has 44 pages with all the table entries on each page. How do I stop all this duplicating?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

Something wrong with the query that's driving it.

by Tony Hopkinson In reply to How do I stop duplication ...

Sounds like you've got a cartesian join in there.
ie where or Join On Clause is always true.

ie if it was Customers and Orders , somewhere in there it should say Order.CustomerID = Customers.CustomerID.

Related Discussions

Related Forums