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

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

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?

Also,

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?
0
J C
Asked:
J C
1 Solution
 
ValentinoVBI ConsultantCommented:
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..
0
 
J CAuthor Commented:
Thank you!
0
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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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