Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Multiple Excel Tabs Using a Single Dataset Expand / Collapse
Author
Message
Posted Monday, April 7, 2014 2:23 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, July 9, 2014 7:28 PM
Points: 77, Visits: 606
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.
Post #1559273
Posted Monday, April 7, 2014 6:41 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, July 9, 2014 7:28 PM
Points: 77, Visits: 606
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?
Post #1559317
Posted Monday, April 7, 2014 7:54 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, July 9, 2014 7:28 PM
Points: 77, Visits: 606
And here's the answer...!!!

http://blog.hoegaerden.be/2011/03/23/where-the-sheets-have-a-name-ssrs-excel-export/

Thanks Me!
Post #1559323
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse