How to Name Worksheets When Exporting SSRS reports to Excel

Home > Blogs > SQL Server > How to Name Worksheets When Exporting SSRS reports to Excel

How to Name Worksheets When Exporting SSRS reports to Excel

1 4 Peter Avila
Added by February 18, 2015

Let’s say we have the following report that shows total sales by product category by territory:

001-SQL-server-SSRS-report-to-excel

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:

002-SQL-server-SSRS-report-to-excel

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.

003-SQL-server-SSRS-report-to-excel

Then, in the Page Breaks category, put a check mark in the Between each instance of a group check box.

004-SQL-server-SSRS-report-to-excel

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.

005-SQL-server-SSRS-report-to-excel

Next, expand the Group property and look for the Page Name sub-property. From its dropdown, select <Expression…>.

006-SQL-server-SSRS-report-to-excel

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.

007-SQL-server-SSRS-report-to-excel

A reference to the field appears in the window at the top of the Expression dialog.

008-SQL-server-SSRS-report-to-excel

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

Videos You May Like

Creating Users and Managing Passwords in Microsoft Office 365

0 657 3

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    

Subnetting a TCP/IP Network using the Magic Box Method

0 1693 5

See our class schedule for complete Course Schedule Training. Classes are held in Phoenix, AZ and can be attended online from anywhere in the world with RemoteLive™. Instructor: Rick Trader  Video Transcription: One of the things that we might have to do in our corporate network is to take a class of IP addresses and then subnet that into … Continue reading Subnetting a TCP/IP Network using the Magic Box Method

Detailed Forensic Investigation of Malware Infections – April 21, 2015

4 615 5

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...

    Share your thoughts...

    Please fill out the comment form below to post a reply.