Multiple Excel Tabs Using a Single Dataset

Question

Multiple Excel Tabs Using a Single Dataset

brickpack

SSCrazy

Points: 2702
More actions
April 7, 2014 at 2:23 pm

#290099

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.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

brickpack SSCrazy Points: 2702 More actions · Answer 1

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?

brickpack SSCrazy Points: 2702 More actions · Answer 2

And here's the answer...!!!

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

Thanks Me!