Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Exporting to Excel, Renaming Sheets

Status
Not open for further replies.

kgreer

MIS
Jul 18, 2003
155
US
I have a question for anyone to answer.

I am exporting a Reporting Service Report to Excel and emailing it to users. I have two sheets that are sent out. I want to know if there is a way to name both sheets when it exports to excel?

Please help!!!!
 
I don't know of any way to do this. Unfortunately, I think that part of the export functionality is hidden.

Of course, you could try using VB to code it and use the Render() method. There are also the SetReportDefinition() and GetReportDefinition() methods that might help.



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top