Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

ssrs 2012 using several paramter values Expand / Collapse
Posted Wednesday, December 25, 2013 12:09 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 6:12 PM
Points: 564, Visits: 699
In an existing SSRS 2012 dashboard application, I need to pass the same 5 parameter values between the existing 48 to 62 sub reports that can be called. I am trying to determine the best way to accomplish this goal.

Listed below are the options I am thinking about:

1. Cascading parameters would not work because all 5 parameter values are not sub values.
2. I could pass the 5 parameter values individually to each sub report; however I am thinking there should be an easier option. There would be a high chance of maintenance problems due to the ability of each sub report being able to call each other and the number of parameters that can be passed.
3. I am thinking that I could pass all 5 parameter values together as 1 combined parameter.
When I was actually accessing each of the 5 parameter values in each applicable sub report, I would use a 'mid' function call to parse out the 5 values I need. Would this option work?
If so how would you setup the code? Would I use some kind of 'custom function'? If so how would you setup the code for the 'custom function'?
4. Do you think the following link would work so I can use the 5 parameter values together?

Do you have any other ideas on how I could accomplish my goal? If so, can you tell me what you are thinking of and show me some code or point me to a URL that will accomplish this goal?
Post #1525911
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse