Subreport records repeat in main report

[Scott Sabo]

Hello-

I have a main report, ITEMS, and a sub report, SOP Items. When I run
the main report, the records from the subreport show under each record
of the main report:

main item #1
Sub item #1
Sub item #2

main item #2
Sub item #1
Sub item #2

etc, etc, etc.

Any ideas why this is happening and how to make it stop?

Thanks-

Scott

 

[Allen Browne]

What is the relationship between ITEMS and SOP Items?

If one ITEM can have several SOP Items, and only the relevant ones should
show up, then presumably your SOP Items table has a foreign key field that
relates to ItemID (the primary key of the ITEM table). If so:
1. Open your report in design view.
2. Right-click the edge of the subreport, and choose Properties.
3. On the Data tab, set the LinkMasterFields to ItemID (ITEM table's primary
key), and the LinkChildFields to the name of the foreign key (the matching
field from the SOP Items table).

If that is not what is going on, I'm not clear what you are after. If you
just wanted to show all the SOP Items at the end of the report (instead of
the relevant ones after each item), then move the subreport into the Report
Footer section (View menu in report design view).