I now have the columns aligned correctly. My issue was in the sub report. I changed the width of the sub report to be the width of the main report, then made the sub data the same X and Width of the headers.
I have extra rows that I cannot figure out where they are coming from. The extra rows are before each new record. I have checked each section of the report and do not find anything that is telling the report to add a row. All of the sections of the report that are showing, not suppressed, and tight on the data in the section without space under.
On the export, these extra rows are just about hidden they are so small in height. I didn't even see them at first.
Here is a screenshot of the row numbers. You can see that rows 18, 22, 26, and 31 and very small, virtually hidden.
How do I get rid of those rows?
Edited by gloworm - 11 Feb 2013 at 5:00am