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 2008 r2 use combined paramter value Expand / Collapse
Posted Tuesday, December 24, 2013 2:39 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: Yesterday @ 8:06 AM
Points: 568, Visits: 705
In an existing SSRS 2008 R2 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 #1525816
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse