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?
RamzyNEbeidAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

thanks,
IT Pros Agree: AI and Machine Learning Key

We’d all like to think our company’s data is well protected, but when you ask IT professionals they admit the data probably is not as safe as it could be.

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/

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
RamzyNEbeidAuthor Commented:
this link is for table and Groups
but i am using 3 subreports each subreport is in a rectangle.

so please advice
thanks,
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.