My report has a main and sub reports. Main report displays the detail and the subreport displays the summary. Only either summary or detail shows up at any time on the report.
I have a suppress logic to that effect.
I have arranged each field to be without any gaps.
But when i export to excel, the main report has some scale breaks.
Example, a field occupies 3 columns in the excel spreadsheet, making it difficult for the users to filter. I have realized that this is because of the columns in the subreport, which are laid out around those cells.
Why should a suppressed subreport have an impact on the columns of the main report?
Is there a way to fix it?
I'm attaching the report (without any data)