Hello!1. One exported file.
There are 4 gridControls with gridViews. I need to export them to one excel file. I know, I can use compositeLink component, but I need to make some configuration of reports' view (add or remove some columns, rename a column caption, create a header band and etc.). So I'll use the reporting.
Could you direct me on the right way to solve the issue?
The project has a dataset with necessary tables.
Here is what I need to get as a result:
2. Each table is on the separate sheet.
3. Three grids are portrait orientation, the fourth grid is very wide, so its orientation is landscape or it should have the limitless width.
Is there way to export the report without preview?
To accomplish this task, create a separate report for each grid. Then create a main a report and use the XRSubreport report to show each child report in the main report. Set the XRSubreport.GenerateOwnPages property to the True value. This allows using different landscape mode for subreports. For each child report, set also the PaperKind property to Custom and the PageHeight property to a large value so the content of each child report can be shown in one page. Create the main report in code and export it to an XLSX file with the XlsxExportOptions.ExportMode property set to SingleFilePageByPage. Should you have further questions, let me know.