Header scales from Main and Sub reports overlapping


  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)
Please help.
Who is Participating?
mlmccConnect With a Mentor Commented:
WHen it formats the export, it doesn't know the subreport is suppressed

ONe thing you can do to avoid this problem is to make sure columns line up.  
Make sure the left edge of a field lines up with the left edge of a field above or below it
Same for the right edge

You can have field overlap as
Field1   Field2

But the left edge of fields 1 and 3 should align and the right edge of fields 2 and 3 should align

There is a document that explains how to format the report for export.
Here is a summary

Here is the document

pvsbandiAuthor Commented:
Thank You! That is a whole lot of work, but i atleast know how now.
Thanks again
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.