Export to Excel Requires Clean-Up of Report Header Printing Multiple Times

You can prevent the Header from printing when the report is exported to Excel by doing one of two things.  First, create a custom report style.  Next, do one of the following in the custom report style.

    1.    From the menu, choose Report, Header - this will remove the checkmark next to the Header option and completely remove the Header band from the Report.  Be careful, there is no “Undo” option on this.

    2.    The recommended way to get rid of the Header is to make it invisible.  To do this, right click on the gray bar below the Header information (bar will be labeled “Header”) and choose Visible.  This will remove the check mark from the Visible option and will make the Header band invisible.