• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 506
  • Last Modified:

How to control Excel Sheet names when exporting to Excel ("Sheet1",Sheet2" is not nice

A very simple scenario.

I have multiple tables on my report.
I'd like to export it to one Excel file with multiple Sheets.
Each table to Sheet.
If I insert Page Break before table it creates a new Sheet in Excell but....
I can't control the sheet name. It's Sheet1,Sheet2,etc.

I also tried to do it using subreports but
it doesn't change anything. Still "Sheet1,"Sheet2".

Is there any way to control those Sheet names?
  • 4
2 Solutions
SThayaTechnical MAnagerCommented:
if you are using SQL server 2008 R2 .. you have an option called "Page Name" from the property window... here you can set your user defined names .

Can you tell me which version are you using
RamzyNEbeidAuthor Commented:
this is the version of my SQL Server that is running the Reporting service

Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64)   Apr  2 2010 15:48:46   Copyright (c) Microsoft Corporation  Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7600: )

but the version from where i am getting the data is :

Microsoft SQL Server 2008 (SP2) - 10.0.4279.0 (X64)   Mar 10 2011 15:03:15   Copyright (c) 1988-2008 Microsoft Corporation  Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)
RamzyNEbeidAuthor Commented:
i have Rectangle and inside this rectangle i added subreport.
in the property of the rectangle i found "Pagename" and i set it to "My Name" and it didnt work.

please advice

Cloud Class® Course: Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

RamzyNEbeidAuthor Commented:
any help?
ValentinoVBI ConsultantCommented:
Have a look at the following article, I believe you'll find it useful: http://blog.hoegaerden.be/2011/03/23/where-the-sheets-have-a-name-ssrs-excel-export/
RamzyNEbeidAuthor Commented:
this link is for table and Groups
but i am using 3 subreports each subreport is in a rectangle.

so please advice
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now