ssrs 2008 r2 relating parameter values

  • 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