subreport displaying multiple times 1

[amoeba102]

Using CR9. I have a main report and 4 subreports. The ones pertinent to my question are: Invoice, context, person. They link this way: Invoice.Main_Context inner join to Context.Context_id. Context.Person inner join to Person.Person_id

I have an invoice subreport. The invoice # is passed into it from the main report. It displays all the invoice line items perfectly, but displays the subreport as many times as there are context records. So everything would be correct if my subreport only showed once per invoice.

Anyone see my error?

 

[lbass]

Insert a group on invoice in the main report and then place the subreport in a group header section. This could be a _b section if you want the subreport below the main header.

-LB

 

[amoeba102]

Worked perfectly. Thank you!