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?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
pvsbandiAuthor Commented:
Thank You! That is a whole lot of work, but i atleast know how now.
Thanks again
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.