Report with Subform multiple repeated pages

[gowans07]

I have a report which is linked to a table which holds order information. Within the report i have included a subreport located within the detail, and obviously it is repeating the detail for as many pages as there are records in the table. How can i prevent this? I only need to read/access the first record in the table?

Thanks TG


*** Solved - Create a Group header on the field that is the master/child of the subform and add the subform to the Group Header ***

 

[Pat Hartman]

The RecordSource for the main report should not include a join to the detail table if you are using a subreport to display the detail.

 

[gowans07]

Just checked the sql for the Report, RecordSource. There's no JOIN located in there... or am i being thick?