SQL Chick

View Original

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

Robert Bruckner's blog