all groups > sql server reporting services > october 2006 >
You're in the

sql server reporting services

group:

Name multiple sheets in excel export?


Name multiple sheets in excel export? pichula
10/31/2006 11:11:14 AM
sql server reporting services:
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.
Re: Name multiple sheets in excel export? Topher
10/31/2006 11:28:40 AM
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.


[quoted text, click to view]
Re: Name multiple sheets in excel export? pichula
10/31/2006 11:36:47 AM
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


[quoted text, click to view]
Re: Name multiple sheets in excel export? Chris Conner
10/31/2006 3:41:06 PM
Have you tried to write a post process that runs on your excel sheet and
renames the exported sheets?

=-Chris

[quoted text, click to view]

Re: Name multiple sheets in excel export? Kaisa M. Lindahl Lervik
10/31/2006 8:29:35 PM
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


[quoted text, click to view]

AddThis Social Bookmark Button