(SSRS) Naming sheets inside of excel dump from SSRS report/Problems with parameters

Posted on 2012-09-08
Last Modified: 2012-09-10
I have a matrix based report and I have it grouped by Project. When I export to excel it creates a sheet for each project which is great. I am just wondering if there is an easy way to name the sheets with the name of the project?


I created a parameter so that our user's can run by Project. I created the filter but when I run the report, the Page Header' with each project still show up. The data is not returned so the filter is working but I'd like to see only the project that we select. Is there a way to accomplish this?
Question by:J C
    LVL 37

    Accepted Solution

    Have a look at the following article:

    You can use the PageName property in the group properties of your Project group.

    Regarding your page header issue: how are both header and filter set up?  What dataset(s) is being used?

    PS: when dealing with two different issues, it's a better practise to open two separate questions..

    Author Closing Comment

    by:J C
    Thank you!

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    I recently went through setting up a JasperReports Server using the AWS EC2 instance, and this article will cover some basic administration tasks I had to perform.
    Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…
    how to add IIS SMTP to handle application/Scanner relays into office 365.

    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

    14 Experts available now in Live!

    Get 1:1 Help Now