April 7, 2014 at 2:23 pm
I have a request for an excel spreadsheet with multiple tabs. Each tab will have a unique customers billing detail. I know how to accomplish this using multiple datasets and page breaks...but I'm thinking there has to be a more efficient way then to create 22 different datasets / sprocs.
April 7, 2014 at 6:41 pm
I was able to use the single DataSet by setting up Row Groups and Page Breaks. Unfortunately...I can't seem to rename each of the excel tabs with the customer name. Does anyone know how to accomplish that?
April 7, 2014 at 7:54 pm
And here's the answer...!!!
http://blog.hoegaerden.be/2011/03/23/where-the-sheets-have-a-name-ssrs-excel-export/
Thanks Me!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy