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

Posted on 2012-09-08
Medium Priority
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

ValentinoV earned 2000 total points
ID: 38381949
Have a look at the following article: http://blog.hoegaerden.be/2011/03/23/where-the-sheets-have-a-name-ssrs-excel-export/

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
ID: 38385044
Thank you!

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hi, In my previous Article  (http://www.experts-exchange.com/Database/Reporting/A_15199-Introduction-to-Microstrategy.html)I discussed some basic understanding of Microstrategy that how we can get in Intro of Microstrategy (MSTR). Now it's tim…
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

850 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