Freeze Panes in Excel

hi,
In matrix row and column grouping there is one property "Group Header should
remain visible while Scrolling",which is equal to Freeze panes property of
Excel.
But when i am exporting the report into Excel i am not getting the same
effect of Static Header.I have to manually set it to get that effort in
exported excel.
So what is the solution of this?
Thanks in advance.
DibakarOn Mar 2, 4:42 am, Dibakar <Diba...@.discussions.microsoft.com> wrote:
> hi,
> In matrix row and column grouping there is one property "Group Header should
> remain visible while Scrolling",which is equal to Freeze panes property of
> Excel.
> But when i am exporting the report into Excel i am not getting the same
> effect of Static Header.I have to manually set it to get that effort in
> exported excel.
> So what is the solution of this?
> Thanks in advance.
> Dibakar
As far as I know, the freeze panes functionality only exists in the
Reporting Services view of the report; though when exported to PDF,
the groups that are frozen are repeated on every page. Sorry that I
could not be of more assistance.
Regards,
Enrique Martinez
Sr. SQL Server Developer