SSRS Question - using VS2012 - How can we make the column headers to freeze ( like Excel )

  • I tired the usual ways but did not work out well.


  • Step1 - Right Click Table, go to Tablix properties

    Step2- ( below )
     

    Step3 - You need to open the advance mode ( as shown below ), Highlight the row that says "STATIC" press F4 to get to the PROPERTIES window.
    Then set the   FIXEDDATA and REPEATONNEWPAGE  

    to True

    Step 4

  • mw112009 - Wednesday, June 14, 2017 6:57 AM

    I tired the usual ways but did not work out well.

    OK I found how to do it ... Done !...

  • 1) On the far right side of the Row Groups/Column Groups panel at the bottom of the project, hit the drop down arrow and select Advanced Mode
    2) Under Row Groups there will be a newly exposed (Static) row. Select this row. This will expose the Tablix Member properties window on the right.
    3) Scroll down to the RepeatOnNewPage property and set it to True.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply