Specifying Subreport Location in the Exported Excel File
If a report contains a subreport, you can specify where the subreport will be put in the exported Excel file in the following way:
- Open the report you want to export, which contains a subreport.
- Select the node that represents the subreport in the Report Inspector.
- In the Properties sheet, set the On New Sheet property as required.
- If you want to put the subreport in the same worksheet together with the primary report, set the value to false.
- If you want to put the subreport in a new worksheet in the exported Excel file, set the property value to true, then enter a name for the new worksheet in the Sheet Name property's value cell. Make sure the name you specify here isn't used by any other worksheets.
- Select File > Export > To Excel.
- In the Export to Excel dialog, make sure Report Format is selected.
- Set the other options as required.
- Select OK to start exporting.
If you set On New Sheet to true, after exporting the report successfully, you will find that the primary report is exported into the first worksheet, and there are some links on it. Select the links to go to the subreport in the second worksheet of the Excel file.
Note: If the subreport are cut into several pages, that is to say you have defined some page settings on the subreport, the links in the primary report will be subreport1_0, subreport1_1, subreport1_2 and so on. You can select the link to see the corresponding part you want.