Specifying subreport location in the exported Excel file

If a report contains a subreport, you can specify where the subreport where 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 panel, 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.
Click File > Export To > Excel.
In the Export to Excel dialog, make sure Report Format is selected.
Set the other options as required.
Click 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. Click 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 click the link to see the corresponding part you want.