- Keeping the column headings at the top when scrolling - a la 'Freeze Panes' in Excel
- Remove pagination for the web based reports
I managed to find the way to do both of these, applied them, then carried on with whatever else I was doing. I don't spend a lot of time in SSRS, probably a couple of days per month, so when I needed to do the same thing to a report today - I couldn't remember where the settings where! So to
try and remember these settings, I'm going to cast them down here, in the vain hope that 1) writing about them will make them stick in my mind a bit more, and 2) failing that I can come back here and remind myself!
To keep the column headings at the top of the report whilst you scroll, (like you can do in Excel with 'Freeze Panes'), set the FixedHeader property of the table (in the Layout section) to True
Removing Pagination from web based reports is achieved by setting the InteractiveSize - Height property of the Report (in the Layout section) to 0
