Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

ssrs 2008 r2 use combined paramter value Expand / Collapse
Author
Message
Posted Tuesday, December 24, 2013 2:39 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, September 25, 2014 11:17 AM
Points: 377, Visits: 446
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?
http://geekswithblogs.net/GruffCode/archive/2012/06/21/using-table-valued-parameters-with-sql-server-reporting-services.aspx

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