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

Posted on 2012-08-27
Last Modified: 2014-04-22
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?
Question by:RamzyNEbeid
    LVL 11

    Assisted Solution

    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

    Author Comment

    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)

    Author Comment

    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


    Author Comment

    any help?
    LVL 37

    Accepted Solution

    Have a look at the following article, I believe you'll find it useful:

    Author Comment

    this link is for table and Groups
    but i am using 3 subreports each subreport is in a rectangle.

    so please advice

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    Written by Valentino Vranken. Introduction: The first step of creating a SQL Server Reporting Services (SSRS) report involves setting up a connection to the data source and programming a dataset to retrieve data from that data source.  The data…
    How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now