Question Locked

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

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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?
Thanks
JB

2 replies

by tony hopkinson

Sounds like you've got a cartesian join in there.
e.g.
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.

This discussion is closed to new replies.