Printing multi copies of one record w/sub-forms 1

[lmcam]

I have created a report and set it up as follows:

-the REPORT consists of data from the main table. (the linking criteria or primary key between the main table and others is the TransactionID.)

-the 1st SUBREPORT contains related issues records/data

-the 2nd SUBREPORT contains related comments records/data

PROBLEM:
Print/print-preview will print/show multiple identical copies for a transactionID where that Main transactionID record has many related records in the issues and/or comments tables.

For example: Where a transactionID has 1 issues record and 3 comments records, 4 identical copies are printed. Another transactionID has 2 issues and 6 comments records so it prints 12 identical copies for that transactionID.

QUESTION:
How can I suppress the multiple reports from printing per unique transactionID? NOTE: Printing the first page per transactionID is not an option as the report is intended to run for all main records and the subreports (issues & comments) contain memo fields where the CanGrow property is "YES" and the data could possibly cause multiple pages for each transactionID#.

Thanks in advance for some advice.

 

[lameid]

The easiest way to suppress this is to fix the recordsource that is causing more than one record to be displayed.

The recordsource for your main form should be based on table(s) where Transacion ID must be unique.

Next your Issues sub report should only be based on unique issues and likewise your comments subreport should only be based on unique comments.

If this doesn't help, please post the SQL of the queries behind each report, list the master and child fields and tell us what section you have them in (detail is probably best).