Repeating Column Headings & Other Advanced Tablix Member Properties in SSRS
After utilizing these properties to repeat column headings in SQL Server Reporting Services, I got curious as to what the rest of the properties do. Here’s a brief reference.
The Advanced Tablix Member Properties are located in the Advanced Mode of the Grouping pane (the down arrow turns Advanced on and off).
Types of Tablix Members
| Type |
Description |
| Static |
Items which repeat once for the row or column group, such as labels or subtotals. -->Settings to repeat column titles on each page are done with static members. |
| Dynamic |
Items which repeat within the group, such as the detail rows. |
Tablix Member Properties
| Property Name |
Default Value |
Description of Use |
| Commonly used: |
||
| FixedData |
False |
Causes headers to behave like Excel’s “Freeze Panes” functionality when scrolling |
| Hidden |
False |
Hides the member |
| HideIfNoRows |
False |
Hides if there are now rows of data (useful to use instead of an iif expression) |
| KeepTogether |
False |
Keeps the entire tablix on one page if possible (this setting may cause white space before it) |
| KeepWithGroup |
After |
After keeps the header with the group of data after the header (Before keeps the footer with the group of data before it) |
| RepeatOnNewPage |
False |
Re-displays the label on every page |
| ToggleItem |
Blank |
Specifies if this member is hidden or shown based on another textbox – this specifies the other textbox that controls it |
| Less commonly used: |
||
| CustomProperties |
Blank |
For use with custom report renderers |
| DataElementName |
Blank |
For use with XML output: sets the name of the element |
| DataElementOutput |
Auto |
For use with XML output: controls whether element should be rendered |
Repeating Column Headings
Settings for the first (Static) member in Row Groups to ensure column headings are repeated on each page & columns are frozen when scrolling in a web browser:
Additional documentation can be found at:
MSDN-Controlling Row and Column Headings
MSDN-How to Display Headers and Footers with a Group