-Dell

Alignment - to prevent column alignment problems in Excel, I do use a cross-tab if possible.  If it's not possible, I do the following:

 

1.  Align the left sides of all of the objects in the column - heading, data, footer/totals.

2.  Make all of the objects the same width, even if most of it is going to be blank.

3.  Avoid headings that are more than one line unless ALL of the headings have the same number of lines.

 

This technique may also work for the Word export.

 

Line Spacing - don't include extra space in a section below the bottom of the objects.  Avoid using lines.  If you're using a cross-tab, you'll get extra space.

 

Good luck!

-Dell

 

I'm not sure why it's not incrementing the page number.

 

If possible, don't use a page header section.  Instead, use an outer group that covers all of your report.  For example, every report we run has a Job ID that identifies which set of data is included from the report tables; we frequently use this as the outer group - especially in subreports when we want page headers.  Modify the group to turn on the option to repeat the group header on every page.  Put your page header information into that section.

 

I don't guarantee that this will work, but it's worth a shot.

 

-Dell