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?
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"
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.