excel export not showing client name in heading

I am putting the client name in my header using ReportItems! reference to
textbox in report - this renders correctly on my server and in pdf however in
excel the client name is not showing up on the report. There are 2 textboxes
overlapping each other because I have 2 groups and when the page spans the
client name will come from the alt text box. I have tried NOT overlapping
them and the result is the same - neither one displays on the export to excel.This is common. In RS 2000, the pdf rendering extension didn't do it...
What you have to do to work around it is use rectangles and textboxes to
simulate a page header OR you can pass it in as a parameter.
-Tim
"MJT" <MJT@.discussions.microsoft.com> wrote in message
news:365BECF1-AD51-42E0-BF79-DE9011DC166C@.microsoft.com...
>I am putting the client name in my header using ReportItems! reference to
> textbox in report - this renders correctly on my server and in pdf however
> in
> excel the client name is not showing up on the report. There are 2
> textboxes
> overlapping each other because I have 2 groups and when the page spans the
> client name will come from the alt text box. I have tried NOT overlapping
> them and the result is the same - neither one displays on the export to
> excel.|||Thanks Tim,
Cant pass as a parm as they use client code (not the same) for the parm
and takes too long to run if I make it a report parm (since it cant be a
query parm I am using a stored procedure). I noticed your post about putting
this info not in a page heading but in a rectangle and hiding/showing which
might be an option if hiding/showing didnt leave white space when hidden (big
problem). Seems like such a simple basic thing that should work, doesnt it?
I mean ... who *doesnt* need data information in their heading'
"Tim Dot NoSpam" wrote:
> This is common. In RS 2000, the pdf rendering extension didn't do it...
> What you have to do to work around it is use rectangles and textboxes to
> simulate a page header OR you can pass it in as a parameter.
> -Tim
> "MJT" <MJT@.discussions.microsoft.com> wrote in message
> news:365BECF1-AD51-42E0-BF79-DE9011DC166C@.microsoft.com...
> >I am putting the client name in my header using ReportItems! reference to
> > textbox in report - this renders correctly on my server and in pdf however
> > in
> > excel the client name is not showing up on the report. There are 2
> > textboxes
> > overlapping each other because I have 2 groups and when the page spans the
> > client name will come from the alt text box. I have tried NOT overlapping
> > them and the result is the same - neither one displays on the export to
> > excel.
>
>|||Hi
Can to tell me to Hide or disable page Header while exporting to Excel format.
calvin
"MJT" wrote:
> I am putting the client name in my header using ReportItems! reference to
> textbox in report - this renders correctly on my server and in pdf however in
> excel the client name is not showing up on the report. There are 2 textboxes
> overlapping each other because I have 2 groups and when the page spans the
> client name will come from the alt text box. I have tried NOT overlapping
> them and the result is the same - neither one displays on the export to excel.|||Hi
I want to export a report to excel format, but in excel the page header
should not come. Can u please help how to slove this.
Calvin
"Tim Dot NoSpam" wrote:
> This is common. In RS 2000, the pdf rendering extension didn't do it...
> What you have to do to work around it is use rectangles and textboxes to
> simulate a page header OR you can pass it in as a parameter.
> -Tim
> "MJT" <MJT@.discussions.microsoft.com> wrote in message
> news:365BECF1-AD51-42E0-BF79-DE9011DC166C@.microsoft.com...
> >I am putting the client name in my header using ReportItems! reference to
> > textbox in report - this renders correctly on my server and in pdf however
> > in
> > excel the client name is not showing up on the report. There are 2
> > textboxes
> > overlapping each other because I have 2 groups and when the page spans the
> > client name will come from the alt text box. I have tried NOT overlapping
> > them and the result is the same - neither one displays on the export to
> > excel.
>
>