Exporting Crystal Reports with linked subreports into one Excel sheet can be achieved by following these steps:
1. Open your Crystal Report that contains the main report and linked sub-reports in Crystal Reports Designer.
2. Ensure that the subreports are properly linked to the main report using the appropriate linking fields.
3. Preview the report to verify that all the sub-reports are displaying correctly within the main report.
4. Go to the "File" menu and choose "Export" -> "Export Report."
5. In the "Export Report" dialog box, select "Microsoft Excel" as the export format and click on the "OK" button.
6. In the "Export Excel" dialog box, choose the desired options for exporting the report. Make sure to select the option to "Export Page Headers and Page Footers."
7. Specify the destination file path and name for the exported Excel file and click on the "Save" button.
8. Crystal Reports will begin exporting the report to Excel. Depending on the size and complexity of the report, this process may take some time.
9. Once the export is complete, you can open the exported Excel file to view the report.
By following these steps, Crystal Reports will export the main report and its linked subreports into a single Excel file, with each subreport appearing in a separate worksheet within the workbook. The export process will retain the formatting, layout, and data of the report, allowing you to view and analyze the information in Excel.
Note : It's important to ensure that the subreports are properly linked within the main report and that they display correctly in the Crystal Reports preview before exporting. Also, keep in mind that the complexity and size of the report, including the number of subreports, may affect the performance and file size of the exported Excel file.
