Question

Locked

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

This conversation is currently closed to new comments.

2 total posts (Page 1 of 1)  
| 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.
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.

Back to Desktop Forum
2 total posts (Page 1 of 1)  

Related Discussions

Related Forums