Report and SubReport Issue (1 Viewer)

[JudyHNM]

I am using Access 2003 coding as Access 2000. I have a report with a subreport. The report has vendor information (name, address, etc), and the subreport has order details from the vendor. This particular line has 4 detail lines on the subreport section. The underlying data source is a query. In both the query and the report itself, I get four lines or four copies of the same report since there are 4 details lines. Each copy of the report is complete, i.e., it has all 4 details lines on it. As a property for the query, I told it to not allow duplicates which apparently is being ignored. How do I do this.

Thanks, Judy

 

[boblarson]

Most likely your parent/child links between the report and subreport aren't set properly. Make sure you are linking on the correct fields.

 

[gemma-the-husky]

iyou may not be printing every column of the query, so although each line is the same, each line of the query is not the same. Maybe there is a unique id in there.

the query property is "unique values", not "unique records"

open the query, rather than the form/report to see what is going on.