Export (0) Print
Expand All

Data Regions in Excel Rendering

SQL Server 2005

A data region is an area on a report containing data from a data source. Types of data regions are charts, lists, tables, and matrices. This topic describing rendering behavior when exporting data regions to Microsoft Excel.

Charts are rendered as pictures, not Excel charts. A chart is rendered the same way as an image element.

List elements show only their contents. The list is rendered for each data row or data group in Excel. Items in the list are positioned on the worksheet relative to their location in the report, which can lead to unexpected results. For this reason, lists are not recommended for incorporation in reports designed to be rendered in Excel.

Tables in reports are rendered as rows and columns of cells in Excel. Page breaks on report items inside a table cell are ignored.

Matrices in reports are rendered as a set of formatted cells in the Excel file, much like the report in HTML. Matrix subtotals are not rendered as formulas, and the matrix is not rendered as an Excel PivotTable. Matrix data regions are fully expanded when rendered in Excel. If you hide all or part of a matrix at design time, at run time the hidden property is ignored and all rows and columns are visible in the report.

For groups, when a group is expanded, both the detail and the subtotal row is displayed. This is different than how groups are shown when viewing them in the HTML Viewer. In the HTML Viewer, when groups are expanded, the subtotal is hidden and the detail is displayed. For an example of this behavior, view the Company Sales report in the HTML Viewer, then Export it to Excel. For more information about sample reports, see AdventureWorks Report Samples.

ms155976.note(en-US,SQL.90).gifNote:
Any data region nested inside of a table or matrix data region is not supported. An error is displayed in Excel if this layout is encountered.

Community Additions

ADD
Show:
© 2015 Microsoft