Report printing duplicate data

[tony9bb]

I've read previous posts with this problem, but I'm not sure how to fix it.
I have a linked transaction table. From that I have 2 Make Table queries to extract detail data of charges and receipts separately. Then I have 2 crosstab queries to sum the charges and receipts by insurance companies.
I have a subreport for charges and a subreport for receipts. Then I built a main report to combine these two reports on one page.
The problem is it generates multiple copies of the same report, the number of Insurance companies in my charges report (ie: 13 copies; there are 13 insurance companies listed in charges). I've looked at the grouping in the crosstab query, but I can't change them. The rowheading is insurance company and the column heading is doctor name and the value is the sum of charges.

Can someone help me figure this out.

Thanks in advance.

tony9bb

 

[tempclerk]

Do you have your master and child forms linked correctly (by company id, for instance)? Or if this should be one single report, not a separate one for each company, etc. then your main form should be unbound.

 

[tony9bb]

Thanks for pointing in the right direction. The main report needed to be unbound.
Thanks again for your help tempclerk.

tony9bb