Operation Manual

Subreports
Combining unrelated reports by using subreports
24
478 Crystal Reports User’s Guide
Combining unrelated reports by using
subreports
At times, you may wish to combine unrelated reports into a single report. For
example, you may want to create a single report that presents:
• Sales grouped by sales representative.
• Sales grouped by item.
While both reports deal with sales data, there is no real linear relationship
between the reports.
Subreports can be used to combine unrelated reports into a single report like
this. While the reports could be based on the same data set, they do not have
to be. They could each be based on entirely different data sets.
Each of these reports is free-standing; the data in any of the reports is not
linked in any way to data in another report. This is the easiest of the subreport
options to work with.
Combining two or more unrelated reports
u To combine two unrelated reports
1. Create the report you want printed first as the primary report.
2. Import an existing report for use as a subreport or create a new
subreport.
3. Place the subreport into the Report Footer and it will print immediately
after the primary report.
u
To combine three or more unrelated reports
1. Create the report you want printed first as the primary report.
2. Import or create each of the other reports you want to use as subreports.
3. Use the Section Expert to insert enough Report Footer sections to match
the number of subreports that you are using.
For example, if you want to use three subreports, insert two new Report
Footer sections so that you have a total of three Report Footer sections.
4. In Report Footer A, place the subreport you want printed immediately
after the primary report. In Report Footer B, place the subreport you want
printed next, and so forth.
The primary report will print first and then the subreports in the order that
you placed them in the report.