How to Name Worksheets When Exporting SSRS reports to Excel
How to Name Worksheets When Exporting SSRS reports to Excel
Let’s say we have the following report that shows total sales by product category by territory:
When we export this report to Excel, we’d like each territory to appear in its own worksheet and each worksheet named after its territory:
How do we make this work? Easy! 1) Put every group on its own page, and 2) name each page using the same field the group uses.
Step 1: Put each group on its own page
To put each group on its own page, open the group’s property window.
Then, in the Page Breaks category, put a check mark in the Between each instance of a group check box.
Click OK to complete this step.
Step 2: Name the pages of the group
With the group selected in the Row Groups panel, press F4 to open the Properties window.
Next, expand the Group property and look for the Page Name sub-property. From its dropdown, select <Expression…>.
In the Expression dialog, select the Fields category and then double-click on the same field the group uses; in this case that would be the Territory field.
A reference to the field appears in the window at the top of the Expression dialog.
Click OK and that’s it! Now, when you export the report to Excel, the worksheet names will match the group names!
Enjoy!
Peter Avila
SQL Server Instructor – Interface Technical Training
Phoenix, AZ
You May Also Like
A Simple Introduction to Cisco CML2
0 3901 0Mark Jacob, Cisco Instructor, presents an introduction to Cisco Modeling Labs 2.0 or CML2.0, an upgrade to Cisco’s VIRL Personal Edition. Mark demonstrates Terminal Emulator access to console, as well as console access from within the CML2.0 product. Hello, I’m Mark Jacob, a Cisco Instructor and Network Instructor at Interface Technical Training. I’ve been using … Continue reading A Simple Introduction to Cisco CML2
Creating Dynamic DNS in Network Environments
0 643 1This content is from our CompTIA Network + Video Certification Training Course. Start training today! In this video, CompTIA Network + instructor Rick Trader teaches how to create Dynamic DNS zones in Network Environments. Video Transcription: Now that we’ve installed DNS, we’ve created our DNS zones, the next step is now, how do we produce those … Continue reading Creating Dynamic DNS in Network Environments
Cable Testers and How to Use them in Network Environments
0 731 1This content is from our CompTIA Network + Video Certification Training Course. Start training today! In this video, CompTIA Network + instructor Rick Trader demonstrates how to use cable testers in network environments. Let’s look at some tools that we can use to test our different cables in our environment. Cable Testers Properly Wired Connectivity … Continue reading Cable Testers and How to Use them in Network Environments
See what people are saying...