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.
4. Do you think the following link would help to solve my problem: http://geekswithblogs.net/GruffCode/archive/2012/06/21/using-table-valued-parameters-with-sql-server-reporting-services.aspx.?
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'?