fixed row header for tablix report when rendered into excel.

Question

Hi I have a tablix report (SSRS 2008) when I render it in excel my client alway needs to see the row headers as fixed one i.e when he/she scrolls report from row 20 scrolling should begin and alway want to see first 20 row and next should be scrolling. Is this possible.Can any one help me in fixing this. Thanks in advance

Answer 1

Hi,

Generally, we are able to keep header visible while scrolling in preview mode or viewing in Report Manager. You can refer to the link below
http://blogs.msdn.com/b/robertbruckner/archive/2008/10/13/repeat-header-and-visible-fixed-header-table.aspx

However, when render the report to Excel, the fixed header will not be frozen automatically. If the requirement is necessary for you, I would suggest you submit a wish at https://connect.microsoft.com/SQLServer/. If the service requests frequency, we may include it in the next release.

Thank you for your understanding. If you have any question, please feel free to ask.

 

Regards,
Tony Chain

---

Tony Chain [MSFT]
MSDN Community Support | Feedback to us
Get or Request Code Sample from Microsoft
Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Answer 2

Hi Tony,

So you are saying that its not possible to fix headers right now in the current release of ssrs 2012 for excel rendering.

Answer 3

Yes, That is a limitation in ssrs. Please place a request @ https://connect.microsoft.com/SQLServer/

---

Please Dont forget to mark helpful posts, and answers. It helps others to find relevant posts to the same question. Milan Das