Record Source

[cfp76]

Is there anyway to have a report have 2 record sources?

I have a report that has 2 subreports within the detail and I am needing to add fields for totals in each subreport but because the main report can only have 1 record source, I get a request for a parameter. How can I do this without getting the pop up box?

Note: If I try to put all the fields in one query or in one report it will not run but give me an error stating there are too many fields defined.

If I cannot have 2 record sources attached to one report - can I increase the number of fields access holds before giving me the too many fields defined error?

 

[pdx_man]

In the main report, reference the controls on the subreport.

=Reports![ReportName]![SubReportName1]!ControlName + Reports![ReportName]![SubReportName2]!ControlName

You can do this easily by creating a text box contol on the main report and clicking on the builder button on the right of the Control Source line. From there, you can map to your controls on the subforms. Make sure you have saved your report first before doing this, as it needs those names to map correctly.