excel export not showing client name in heading

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MJT - 21 Jun 2006 21:16 GMT

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.

Reply to this Message

Tim Dot NoSpam - 21 Jun 2006 21:30 GMT

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

>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
[quoted text clipped - 5 lines]
> them and the result is the same - neither one displays on the export to
> excel.

Reply to this Message

MJT - 21 Jun 2006 21:43 GMT

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??

> This is common. In RS 2000, the pdf rendering extension didn't do it...
>
[quoted text clipped - 12 lines]
> > them and the result is the same - neither one displays on the export to
> > excel.

Reply to this Message

calvin - 30 Jun 2006 13:59 GMT

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

> This is common. In RS 2000, the pdf rendering extension didn't do it...
>
[quoted text clipped - 12 lines]
> > them and the result is the same - neither one displays on the export to
> > excel.

Reply to this Message

calvin - 30 Jun 2006 13:56 GMT

Hi

Can to tell me to Hide or disable page Header while exporting to Excel format.

calvin

> 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.

Reply to this Message