August 4, 2014 at 2:03 pm
Does SSRS 2008 have a workaround or hack to rename the Excel Tabs after implementing a page breaks? I notice that this isn't officially fixed until 2008 R2 but I was wondering if there is a workaround to fix this - instead of having Sheet1, Sheet2 etc - besides manually renaming each excel. Thank you.
August 4, 2014 at 6:34 pm
This blog post may help you get the output you want:
http://blogs.msdn.com/b/robertbruckner/archive/2010/05/16/report-design-naming-excel-worksheets.aspx
August 5, 2014 at 7:19 am
geoff5,
Thank you for the article. However, it appears that this is for 2008 R2. I only have 2008 to work with.
Thanks
August 5, 2014 at 7:47 pm
Here is another article that may have the solution you want. It is much more technical and actually tells how to use Excel's XSLT style sheet feature to achieve the result, not anything in SSRS per se. It doesn't seem to be particularly easy to set up, but once you have the XSLT document prepared and have practiced the process once or twice, I think it would not be a huge undertaking to do it each time you run the report.
This technique is listed as workable for SSRS 2005, so I assume it would work with 2008 as well. It might even work with SSRS 2008 R2, though it would be much easier to use the built-in option after you upgrade to that version.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply