Rendering Headers and Footers in Excel Report Output

Some limitations apply when exporting reports with headers and footers to Excel. To export headers and footer successfully, consider the following:

• List frames and crosstabs added to report headers or footers are not rendered in Excel format.

• Scoped data is not applied in Excel report output. Only the first data grouping is used in the Excel header or footer. For information about keeping the objects in the data group together on export, see .

• Text length cannot exceed 256 characters.

• The ability to position text is limited.

• Text color, background color, borders, and patterns cannot be set.

• Images cannot be added.

Exporting Row and Column Titles to Excel

When column titles are exported to Excel, they are treated as Excel titles that repeat on the top of each printed page. It is as if the Excel page setup option, Rows to appear at top, was selected.

When row titles in crosstab reports are exported, row titles repeat at the left of each printed page. It is as if the Excel page setup option, Columns to repeat at left, was selected.

If a report splits across more multiple worksheets, the column and row titles are repeated as well. However, they are added only to the worksheets that contain the list frame or crosstab report that use the column and row titles.