Freeze table header

When exporting a report to excel, Is there any way to keep the table
header from scrolling up in the excel output when a user scrolls down
through the data?
I noticed that anything that's put above the page header is frozen
when the report is exported to excel.
But when I tried placing the table headers in text boxes and putting
them in the page header area, the headers are out of alignment when
it's exported to excel.On the table you can have the header freeze when you scroll.Right click for
properties and last option.
Amarnath
"bevarg" wrote:
> When exporting a report to excel, Is there any way to keep the table
> header from scrolling up in the excel output when a user scrolls down
> through the data?
> I noticed that anything that's put above the page header is frozen
> when the report is exported to excel.
> But when I tried placing the table headers in text boxes and putting
> them in the page header area, the headers are out of alignment when
> it's exported to excel.
>|||I have that option set to True but it doesn't work when I export it to
Excel. It seems to work only when you are viewing the report within
report manager and you have multiple pages.
On Apr 25, 5:24 am, Amarnath <Amarn...@.discussions.microsoft.com>
wrote:
> On the table you can have the header freeze when you scroll.Right click for
> properties and last option.
> Amarnath
> "bevarg" wrote:
> > When exporting a report to excel, Is there any way to keep the table
> > header from scrolling up in the excel output when a user scrolls down
> > through the data?
> > I noticed that anything that's put above the page header is frozen
> > when the report is exported to excel.
> > But when I tried placing the table headers in text boxes and putting
> > them in the page header area, the headers are out of alignment when
> > it's exported to excel.|||On Apr 26, 1:16 pm, bevarg <benovargh...@.gmail.com> wrote:
> I have that option set to True but it doesn't work when I export it to
> Excel. It seems to work only when you are viewing the report within
> report manager and you have multiple pages.
> On Apr 25, 5:24 am, Amarnath <Amarn...@.discussions.microsoft.com>
> wrote:
> > On the table you can have the header freeze when you scroll.Right click for
> > properties and last option.
> > Amarnath
> > "bevarg" wrote:
> > > When exporting a report to excel, Is there any way to keep the table
> > > header from scrolling up in the excel output when a user scrolls down
> > > through the data?
> > > I noticed that anything that's put above the page header is frozen
> > > when the report is exported to excel.
> > > But when I tried placing the table headers in text boxes and putting
> > > them in the page header area, the headers are out of alignment when
> > > it's exported to excel.
You are correct. Unfortunately, you would have to manually set this in
Excel (via Window -> Freeze Panes).
Regards,
Enri|||What you can do is to just align all the table header on the header of the
page then remove the table header, so that header will be frozen. yes page
header is frozen and not table header.
Amarnath
"bevarg" wrote:
> I have that option set to True but it doesn't work when I export it to
> Excel. It seems to work only when you are viewing the report within
> report manager and you have multiple pages.
> On Apr 25, 5:24 am, Amarnath <Amarn...@.discussions.microsoft.com>
> wrote:
> > On the table you can have the header freeze when you scroll.Right click for
> > properties and last option.
> >
> > Amarnath
> >
> > "bevarg" wrote:
> > > When exporting a report to excel, Is there any way to keep the table
> > > header from scrolling up in the excel output when a user scrolls down
> > > through the data?
> >
> > > I noticed that anything that's put above the page header is frozen
> > > when the report is exported to excel.
> > > But when I tried placing the table headers in text boxes and putting
> > > them in the page header area, the headers are out of alignment when
> > > it's exported to excel.
>
>