Rendering Data Regions (Report Builder and SSRS)
In addition to the general rendering behaviors that apply to all report items, data regions have additional pagination and rendering behaviors that they follow. Data region-specific rendering rules include how a data region grows, how special cells such as the corner cell or header cells are rendered, and how a data region for right-to-left reading is rendered. This topic discusses how the various parts of a data region are rendered.
You can create and modify report definitions (.rdl) in Report Builder and in Report Designer in SQL Server Data Tools. Each authoring environment provides different ways to create, open, and save reports and related items. For more information, see Designing Reports in Report Designer and Report Builder (SSRS) on the Web at microsoft.com.
The tablix data region, which enables you to create tables, matrices, and lists, is rendered as a grid comprised of columns and rows. The intersection of a row and a column is a cell. When rendered, this cell can contain data or other report items, such as images, rectangles, text boxes, or subreports. A tablix data region can grow vertically and/or horizontally. In addition, the corner cell, the data region header cells, and the data region body cells may grow based on their contents. If the data region spans multiple pages, report items that are set to repeat with the data region are rendered on every page on which the data region is displayed. For more information, see Tables, Matrices, and Lists (Report Builder and SSRS).
Right to Left
A tablix data region set to display from right to left is rendered with its structure as a mirror image of the data region if it were rendered left to right. The corner of the data region appears in the upper right corner. If dynamic columns exist in the report, they expand to the left. Right-to-left settings do not affect the order of the data in the data region; your columns are simply ordered differently.
Tablix headers are rendered as a row header or a column header depending on where the header cell appears in the row group hierarchy or the column group hierarchy. If a logical page break exists within the cell contents of a header, it is ignored. Logical page breaks on column groups are ignored.
Logical page breaks on groups do not cause outer group headers to break. For example, suppose your report has an outer group of country and an inner group of country region. If there is a logical page break between instances of the country region group, the outer group, the country, will appear on both pages of the report.
Repeated Tablix Headers
When the RepeatWith property is set in the Properties pane, items that do not change within the data region, such as column headers, repeat on each page where that part of the data region is rendered. For example, if a row of data appears on the next page and the Repeat With property is set, the column headers appear on the rendered page as well.
The upper left corner is called the tablix corner. The Tablix corner can contain other report items within it but, if logical page breaks are inserted in the corner, they are ignored when the Tablix data region is rendered.
The Tablix body is made up of Tablix cells. The Tablix body is rendered based on pagination rules and the rendering behaviors of report items. For more information, see Rendering Report Items (Report Builder and SSRS).