sql-serverreporting-servicessql-server-2008-r2

Keep report header visible while scrolling


I often check the following option in the hope that it will be implemented when the report is rendered on the RS web portal - but it never works...

enter image description here

The reports usually have some Row Groups - does this have an impact on whether this option will work?

Or is this a bug in Reporting Services?


Solution

  • I find it usually doesnt work as advertised and you have to find the "Advanced mode" button (a strong candidate for the worst piece of UI ever) and then fiddle with several properties.

    Here's probably the best reference:

    http://blogs.msdn.com/b/robertbruckner/archive/2008/10/13/repeat-header-and-visible-fixed-header-table.aspx