im trying to export a Crystal Report to Excel that has several separate subreports for header and details. I have set the variable ExcelAreaType to AreaSectionKind.Detail in the report's ExcelFormatOptions object :
The resulting Excel file has a properly formatted detail section but the report header and page header are shifted to the right.
On changing the code to:
I get a properly formatted header but the details section field are shifted.
My question is this: How do we specify different Excel export options for the individual subreports when we are exporting only a single report (containing subreports) ? And if we cant, then what is the workaround for this issue ?