By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,662 Members | 1,758 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,662 IT Pros & Developers. It's quick & easy.

Adding Subreports to reports

P: 74
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
Jan 28 '10 #1
Share this Question
Share on Google+
3 Replies

Expert 2.5K+
P: 3,072
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 ?

Jan 28 '10 #2

Expert Mod 100+
P: 2,321
You can create a report with no recordsource, then place all 3 supreports in the detail section of that report.
Jan 28 '10 #3

Expert Mod 15k+
P: 31,271
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.
Jan 30 '10 #4

Post your reply

Sign in to post your reply or Sign up for a free account.