June 4, 2009 at 8:22 am
Hi
I have 12 reports in my current project (SSRS 2005), what I would like to do is to pass the reporting period as a global parameter/value.
When the user select 200904 on one report it should be passed on to all the other reports in the solution. Is this possible and if so how do I do that.
June 4, 2009 at 10:22 am
Are these subreports or reports you have to navigate to through the report server interface?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
June 5, 2009 at 12:52 am
They are reports not subreports. I would navigate to them through server interface
June 5, 2009 at 5:32 am
I don't know of a way to "cache" parameters for use by multiple reports when navigating through the RS interface. The only way would be to setup defaults for the parameters, but that is not really what you want.
Edit: Fixed typos. If I can see then at midnight after a full day of SQLSaturday they must be bad:-P
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
June 5, 2009 at 8:04 am
I'm with Jack on this one. The only 2 alternatives (ie hacks) i can think that you could try would be:
- to include some level of navigation *within* each report (e.g. use a standard header that has links to the other reports, using these links pass the current parm values);
- or wrap your own outer layer of control (e.g. aspx app, you handle the collection of parm values in this app, and then have links to your reports, when the user selects a report, you pass the selected parm value to that, and each subsequent, report).
Steve.
June 8, 2009 at 1:28 am
Thanks for the feedback guys. I think I will use Steve's Idea
- or wrap your own outer layer of control (e.g. aspx app, you handle the collection of parm values in this app, and then have links to your reports, when the user selects a report, you pass the selected parm value to that, and each subsequent, report).
But currently I am just going to develop all the reports first then will get to that.
Thank you guys for the feedback
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply