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
Creating Users and Managing Passwords in Microsoft Office 365
In this Office 365 training video, instructor Spike Xavier demonstrates how to create users and manage passwords in Office 365. For instructor-led Office 365 training classes, see our course schedulle: Spike Xavier SharePoint Instructor – Interface Technical Training Phoenix, AZ 20347: Enabling and Managing Office 365
JavaScript for C# Developers – September 24, 2014
Is JavaScript worth taking the time to learn if I’m a server-side .NET developer? How much of C# carries over to JavaScript? In this recorded video from Dan Wahlin’s webinar on September 24,2014, Dan answers these questions and more while also discussing similarities between the languages, key differences, and the future of JavaScript (ES6). If … Continue reading JavaScript for C# Developers – September 24, 2014
Detailed Forensic Investigation of Malware Infections – April 21, 2015
How does an investigator hunt down and identify unknown malware? In this recording of our IT Security training webinar on April 21, 2015, Security expert Mike Danseglio (CISSP / CEH) performed several malware investigations on infected computers and identify symptoms, find root cause, and follow the leads to determine what’s happening. He demonstrated his preferred … Continue reading Detailed Forensic Investigation of Malware Infections – April 21, 2015
Write a Comment
See what people are saying...