March 15, 2010 at 2:22 pm
Hello,
I've been reading about how difficult it is to rename tabs on a Excel rendered report using SSRS. I can't believe how something so trivial is virtually impossible to do.
What if I create a subscription for the report that will send it to a file share and then have some code rename the tabs on the physical file.
Has anyone come up with a solution such as this?
Thanks!
March 15, 2010 at 2:36 pm
Definitly possible to do.
Put all the subscriptions into a special folder.
Then loop in all excel files.
Then rename all tabs for each files.
Definitly a kludge, but that would work.
March 15, 2010 at 3:37 pm
Ninja's_RGR'us,
Do you have any examples of how to do this? Or can you recommend another way to accomplish this task?
Thanks
March 16, 2010 at 3:16 am
I used another method... not quite as good but acceptable for the users. For the 203 reports that needed this I changed the group by to the description instead of the code and by keeping the new page for each group, that created meaningfull new pages in excel export.
If you want to go the manual way, do a search for vba code to rename excel tabs. You should be able to adapt that to use back in a sql job or vbs file.
March 16, 2010 at 10:47 am
Thanks for the reply!
Ninja's_RGR'us (3/16/2010)
I changed the group by to the description instead of the code and by keeping the new page for each group
I'm not sure what you mean by this. Could you please show me an example?
Thanks
March 16, 2010 at 12:44 pm
If memory serves well : Tablix, create new group. Page break after the group. On export there should be a new tab for each group in excel.
From there on out you can play with the groupings untill you get what you need.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply