Adding Subreports to reports

[jimleon]

Hi all....

I have 3 reports - Report1, Report2 and Report3 each one being supplied by quieries query1 - query3 repectively. I need a report that will output all 3 each one starting on a fresh page, with a cost total at the end of the report.
I'm guessing this is somehow achieved using subreports added into the first report but I just cant get it to work....

Any ideas where I'm going wrong people?

Many thanks in advance

[nico5038]

When the data columns are the same I would just change query1/2/3 into a UNION with these three queries.
By having an additional "1"/"2"/"3" literal added as first column you'll be able to create a grouping level that allows a pageskip after printing the group.

Biggest benefit is the easy totalling of the three groups by an unbound field in the report footer holding "=Sum([summingfieldname])

Getting the idea ?

Nic;o)

[TheSmileyCoder]

You can create a report with no recordsource, then place all 3 supreports in the detail section of that report.

[NeoPa]

I would think subreports would be required.

See Referring to Items on a Sub-Form for the general idea of how to get the information from the subreports to be able to be totalled on the main one. Clearly each subreport would need a control where the total for that report is shown so that it is able to be referenced.