Rendering to Excel, multiple sheets

I am rendering a report from RS that has multiple tables. After each table I
have it setup to have a page break. This causes each table to be written to
a different sheet within the excel workbook. This is fine. What I would
like to know is if there is a way to write the table name to the excel
workbook tab when the report is rendered instead of having the tabs show
sheet1, sheet2, etc. DOes anyone know how or if this can be done?
Thanks for your help,
sOn Oct 11, 10:24 am, Susan R <Sus...@.discussions.microsoft.com> wrote:
> I am rendering a report from RS that has multiple tables. After each table I
> have it setup to have a page break. This causes each table to be written to
> a different sheet within the excel workbook. This is fine. What I would
> like to know is if there is a way to write the table name to the excel
> workbook tab when the report is rendered instead of having the tabs show
> sheet1, sheet2, etc. DOes anyone know how or if this can be done?
> Thanks for your help,
> s
Several people have asked this same question on these forums w/pretty
much the same response: this is not currently possible in SSRS. Sorry
that I could not be of greater assistance.
Regards,
Enrique Martinez
Sr. Software Consultant|||Hi,
I never tried it my myself, but facing the same problem I found
http://www.spacefold.com/lisa/post/Changing-the-Sheet-names-in-SQL-Server-RS-Excel-QnD-XSLT.aspx
Seems to do the job, but is a little tricky to setup and works only for
excel 2003 and newer.
Simon
"Susan R" wrote:
> I am rendering a report from RS that has multiple tables. After each table I
> have it setup to have a page break. This causes each table to be written to
> a different sheet within the excel workbook. This is fine. What I would
> like to know is if there is a way to write the table name to the excel
> workbook tab when the report is rendered instead of having the tabs show
> sheet1, sheet2, etc. DOes anyone know how or if this can be done?
> Thanks for your help,
> s