If you select connect to a new Data source, it will open New Data source connection window from which you can choose a new data source. Once you choose new data source, you need to define the relationship between the main report and the subreport. If you click on Page tab it will show the data of Subreport in the main report. Move the cursor to where you want it to appear in the report, and click to place it.
|Published (Last):||22 March 2019|
|PDF File Size:||18.98 Mb|
|ePub File Size:||7.41 Mb|
|Price:||Free* [*Free Regsitration Required]|
Subreports in Crystal Reports also cannot contain another subreport within them. Subreports in Crystal Reports allow you to access and display information from two unrelated reports in a single report, or display multiple views of report data in a single report. You can create either linked or unlinked subreports in Crystal Reports Unlinked subreports in Crystal Reports simply have no relationship between the records displayed in the subreport and the records displayed in the main report.
In linked subreports in Crystal Reports , the data in the subreport is matched to data in the primary report. On-demand subreports in Crystal Reports are displayed within their own object frame in the main report, which reduces the amount of display space required within the main report.
When you create a link between the primary report and the subreport, they are linked together by a parameter field. At the bottom of the dialog box, use the drop-down at the left side of the dialog box to select the parameter field to use from the primary report. Select the associated field from the subreport to use for the link from the drop-down at the right side of the dialog box.
Then you can click into the position within the report at which you want to place the linked subreport. Click into the place within the report where you want to create the linked subreport.
Export subreport with main report
Crystal Subreports - Overview
Exporting Subreport to Excel