Menu
I have a simple table in ssrs with a single header row and no grouping. I want to freeze the columns while scrolling. I have set the properties of table(Fixed column headers AS true) . I have also checked the checkbox which says"Headers should be visible while scrolling" but still it doesn't work.
What should i do?
687
Select the cell below the rows and to the right of the columns you want to keep visible when you scroll. Select View > Freeze Panes > Freeze Panes.
With the relevant Static group selected you will see that the Properties Window on the right hand side reflects the properties for this object now: Locate the property called RepeatOnNewPage and set this to True (as shown above). The column Headings for the table will now be repeated across all pages.
I think this can be fixed by setting the FixedData property to True in Advanced Mode. To get to Advanced Mode, click the down arrow on the grouping pane, select Advanced Mode, then select Details and check the properties there.
83
The easiest way I found is this one. The Fixed Group property did not work for me.
40
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
