April 24, 2015 at 4:10 pm
In an existing ssrs 2008 r2 report, I have a requirement from a user where they want to add 2 more parameters to the report. Right now there is an option where the user can choice to generate report1, report2, report3, report4, report5, report6, report7, report8, and/or any combination of the reports I just listed.
This is setup by using an expression in the visibility property for each of the 8 tablixes.
For your information, the following is an example of how to display one of the reports or not:
=iif(InStr(join(Parameters!report.Value,","),6)>0,false,true)
Now the user wants to be able to add the parameters of customer and inventory_item based upon if report7 and/or or report8 is selected.
Now can you tell me the following:
1. Would you show me the code I can use in the dataset to select report7 and/or report8?
2. Is this considered using 'optional' parameters since they new parameters of inventory_item are based upon if report7 and/or or report8 is selected. If so,
can you show me how I can code for these optional parameters?
3. If the above is not possible to select specific reports, then would the dataset query need to look something like:
where @report is null or where @report is not null? What would you suggest?
4. If the above options are not possible for the 2 new parameters, would I have all items (or one item)selected so that the reports would run all the time?
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply