Name multiple sheets in excel export?

I have a report that when exported to Excel creates multiple sheets. Im
doing this on purpose. I wanted know if anyone new a way to
automatically name the Sheets in the Excel export? I wanted to name
them from a field on the report.I don't believe this is possible in the current versions of Reporting
Services. It seems like a functionality that would have a great deal
of value for reporting purposes, so hopefully MS will include this
feature in a future service pack.
pichula wrote:
> I have a report that when exported to Excel creates multiple sheets. Im
> doing this on purpose. I wanted know if anyone new a way to
> automatically name the Sheets in the Excel export? I wanted to name
> them from a field on the report.|||I'm pretty sure you can't do this. I'm very sure you couldn't do it with RS
2000 (tried to find info about it myself a while ago), and I don't think you
can do it in RS 2005 either.
A pity, really, as it would be very usefull!
Kaisa M. Lindahl Lervik
"pichula" <kansas4451@.yahoo.com> wrote in message
news:1162321874.757668.47520@.e64g2000cwd.googlegroups.com...
>I have a report that when exported to Excel creates multiple sheets. Im
> doing this on purpose. I wanted know if anyone new a way to
> automatically name the Sheets in the Excel export? I wanted to name
> them from a field on the report.
>|||Thanks for your replies. If this is not possible in RS 2005, does
anybody know about any workaround to this problem? Maybe using Excel
macros, etc.
elPablo
Kaisa M. Lindahl Lervik wrote:
> I'm pretty sure you can't do this. I'm very sure you couldn't do it with RS
> 2000 (tried to find info about it myself a while ago), and I don't think you
> can do it in RS 2005 either.
> A pity, really, as it would be very usefull!
> Kaisa M. Lindahl Lervik
>
> "pichula" <kansas4451@.yahoo.com> wrote in message
> news:1162321874.757668.47520@.e64g2000cwd.googlegroups.com...
> >I have a report that when exported to Excel creates multiple sheets. Im
> > doing this on purpose. I wanted know if anyone new a way to
> > automatically name the Sheets in the Excel export? I wanted to name
> > them from a field on the report.
> >|||Have you tried to write a post process that runs on your excel sheet and
renames the exported sheets?
=-Chris
"pichula" <kansas4451@.yahoo.com> wrote in message
news:1162321874.757668.47520@.e64g2000cwd.googlegroups.com...
>I have a report that when exported to Excel creates multiple sheets. Im
> doing this on purpose. I wanted know if anyone new a way to
> automatically name the Sheets in the Excel export? I wanted to name
> them from a field on the report.
>