Share via


Exporting a Report as a Microsoft Excel File (Report Builder)

The Excel export option in Report Builder is compatible with Microsoft Excel 97 and later; it saves the report as an Excel spreadsheet and tries to preserve the layout and original design of the report. Because of this, you need to take certain considerations into account when saving your report as an Excel file.

Note

The format for reports rendered as Microsoft Excel is Binary Interchange File Format (BIFF).

When a report is saved as an Excel file, each page in the report becomes a worksheet and looks similar to the report you exported. There is a limit to the number of worksheets that Excel can have per workbook, and an error is generated if the limit is exceeded.

Excel supports only a predefined set of colors. When the report is saved as an Excel file, Excel takes the colors used in the report and maps them to the best match.

In This Section

Topic Description

Limitations with Exporting to Excel (Report Builder)

Describes limitations in Excel that may cause errors in the report when saving it to Excel.

Report Item Behavior when Exporting to Excel (Report Builder)

Describes how Excel saves charts, tables, matrices, and text.

Page Layout when Exporting to Excel (Report Builder)

Describes the page orientation, pagination, and section breaks.

See Also

Tasks

How to: Export a Report as a Different File Type (Report Builder)

Concepts

Exporting a Report as a Different File Type (Report Builder)
Design Considerations for Exporting a Report as a Different File Type (Report Builder)

Help and Information

Getting SQL Server 2005 Assistance