SaravRaj
SaravRaj

Reputation: 23

How freeze Tablix Header in SSRS

How to freeze the Tablix header after export to excel from rdl in SSRS.

I am using report builder 3.0.

Upvotes: 0

Views: 6543

Answers (1)

dev_etter
dev_etter

Reputation: 1186

For example, if you set properties to repeat column headers and to keep column headers in view, when you export the report to Excel, the column headers appear at the top of each worksheet and the Freeze Panes feature is enabled for that row.

Found here: Controlling Row and Column Headings (Report Builder 3.0 and SSRS)

EDIT: Even though the documentation in the MSDN link above makes it appear that this is possible, further web searches allude that it is not possible to freeze column headers in a tablix when rendered. It can only be done to Report Headers.

Upvotes: 1

Related Questions