Report Item Behavior When Exporting to Excel (Report Builder 1.0)
Some report items contain data from your underlying data source, such as charts, tables, and matrices. Other report items contain data that you enter, such as text boxes. This topic describes how these report items behave when the report is exported to Excel.
Charts
Charts are saved as pictures, not Excel charts.
Tables
Tables in reports are saved as a set of formatted cells in Excel, similar to the rows and columns within the report when you run it.
Matrices
Matrices in reports are saved as a set of formatted cells in the Excel file, much like the report when you run it. Matrix subtotals are not saved as formulas, and the matrix is not saved as an Excel PivotTable. Matrix data regions are fully expanded when saved in Excel.
Text Boxes
Text boxes are exported and appear as formatted text in the Excel file. If the text string is longer than one cell width, multiple cells are merged to accommodate the text.
Images
Fields in Report Builder can contain images. When images are rendered to Excel, they are rendered as static pictures.