Hello I have a SQL RS report which uses a single matrix. In the first colum of the matrix Groupping and Sorting Properties I hav checked Group header should remain visible while scrolling. However, when I export the report to excel, the headers in the excel report are not frozen. Is there any way in SQL RS t set the Matrix so that when the data is extracted to Excel, the header are frozen? Thank you.

Hello, I'm afraid it isn't possible. Excel uses different rendering extension which doesn't support this feature even if renderer to html does JiriJiri Neoral BIExperts s.r.o. www.biexperts.cz

However, to work around the issue, you can freeze the pane in Excel level. Please follows these steps: 1. Click the header row 2. Click View menu on top of the toolbar, then you will Freeze Panes 3. Select one kind of Freeze based on your requirement. This link supplies the detailed steps http://inpics.net/tutorials/excel2007/vis5.html Best regards, Challen Fu Please remember to mark the replies as answers if they help and unmark them if they provide no help.