Freeze Group Header (not table header)?

• peterzeke

  SSCrazy Eights

  Points: 9003

  More actions

  November 17, 2014 at 1:07 pm

  #312705

  I've been working with SSRS 2005 for a bunch of years now, and I've just come across a report design request that I can't seem to pull off. It should be easy, but the solution eludes me.

  I'm developing a report that contains 1 table and 1 dataset (that's it).

  The table contains a group (called "category"). There's a page break between each group. I'd like to freeze the group row header for each page, similar to a table header property of "header should remain visible while scrolling". Unfortunately, group headers lack this property, and I can't seem to find a way to imitate the behavior.

  Here are some other key points:

  1) The group header contains a field called "Total Rows" that displays the total # of rows within a group: =RowNumber("table1_Group1").

  2) The first couple of left-most columns have their FixedHeader property set to True. (The report has many columns, so horizontal scrolling is inevitable. Keeping the first few columns visible maintains context.)

  3) Lastly, the report will be exported to excel. So, for each group, a worksheet will be conveniently/automatically created.

  I've tried various approaches to solving the main problem, but each approach creates problems elsewhere. So, I thought I'd reach out to the greater SSRS development community for some possible suggestions/solutions.

  Thanks in advance,

  --Pete