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

Comments

[FP]

This really helped! Thanks Melissa.

[Alexander]

Not working on my side. Still don't have frozen panes in excel rendered result.

[Alexander]

Notify me

[Melissa Coates]

Alexander:

The functionality described above is for rendering an SSRS report within a web browser. To my knowlede, frozen panes can't be automatically transferred to a renderer like Excel.

Melissa