How to freeze First Column in tabular Report?

reporting-services ssrs-tablix ssrs-2008-r2
SqlLearner picture SqlLearner · May 1, 2014 · Viewed 14.1k times · Source

I have a Table Report with 70 columns. My requirement is to freeze the First Column as I scroll horizontally.

I have tried checking row headers in Tablix properties, but still it's not working. How can I freeze the first Column?

Answer

Anup Agrawal picture Anup Agrawal · May 1, 2014

Here are the steps for Freezing columns/rows in SSRS

Step1. Go to Groupings pane at the bottom and select Advanced Mode.

enter image description here

Step2a. Select the Static Member under Column Groups and it will highlight the column where it points to. In the properties mark the FixedData to True

enter image description here

For future ref:

Step 2b. For freezing rows you would set the FixedData property of Static members under Row Groups.

Related questions

How to hide parameter based on another parameter value in SSRS

Hi I have 2 parameters param1 and param2. param1 has values true and false.my requirement is if i select true in param1 then param2 should be hidden and if i select false in param1 then param2 should be visible. can …

Read More
how to display multivalued parameter value in SSRS text box

I am having a multivalued parameter 'client',i have almost 60 values in the client parameter,my requirement is display the selected client values in the header text box but when i select 'SELECT ALL' option in the parameter i should …

Read More
How to align different Tablix in SSRS

I have a SSRS report in which i need to align multiple tablix in same Order as i need to export to EXCEL The other tablix's is just a copy of the first tablix with only change of data set.…

Read More