crystal reports 2011 Sub reports / loops
Posted on 2014-03-20
Crystal report 2011
Version 126.96.36.1998 TRM
I have a report that has a main report with a page header defined. The main report is used to select the input parameters. The main report calls 6 sub reports; each sub report is defined in its own separate report footer. Three of the sub reports are cross tab reports. The main report does not use the detail section.
The user selects a set of parameter for the report. These parameters are displayed as part of the page header.
The user now wants to be able to do a select of “ALL” on one of the input parameters. The idea is to generate a concatenated report. So the header and six sub reports would execute for the first item in the list, the next item and so on. The list can be controlled by a data base select, so the user only selects the ALL item.
I have done this before by converting the main report to a sub report and then calling the subreport in a group by detail section detailed section. But in that case the main report did not have call to a sub report.
I know that subreports cannot call subreports (if it could it would simplify this problem).
Any idea on how to do this with such a complicated report?