Printing report with subreport (1 Viewer)

[robert693]

I have button on a form that prints a report with just the record of the current ID number in the form. The report has a subreport in it and although all of the subreport comes up in the printing, a copy of the report prints for each record in the subreport. For example if I had a Customer report with an orders subreport in it and printed it, the report would print showing the customer with the number form the form and will have all the orders but will print as many copies as there records in the orders subreport. Any help with this would be greatly appreciated.

 

[Sara Overton]

Create a footer to put your subreport into by going into View>Sorting and Grouping.

In the Sorting and Grouping box...
In a new line under the "Field/expression" column select Customer ID. Select Yes in Group Footer from the properties box.

A Customer ID Footer will appear. Pop your subreport in here.

If you have 1 subreport you should have 2 entries in sorting and grouping -
1. Group header - yes
"Field/Expression" -Customer ID

2nd one as detailed above.

On your subreport ensure the links to your child and master fields in the normal properties box are both Customer ID.

Let me know if this works