Name multiple sheets in excel export?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

pichula - 31 Oct 2006 20:11 GMT

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.

Reply to this Message

Topher - 31 Oct 2006 20:28 GMT

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.

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

Reply to this Message

Kaisa M. Lindahl Lervik - 31 Oct 2006 20:29 GMT

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

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

Reply to this Message

pichula - 31 Oct 2006 20:36 GMT

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

> 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
[quoted text clipped - 7 lines]
> > automatically name the Sheets in the Excel export? I wanted to name
> > them from a field on the report.

Reply to this Message

Chris Conner - 31 Oct 2006 21:41 GMT

Have you tried to write a post process that runs on your excel sheet and
renames the exported sheets?

=-Chris

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

Reply to this Message