none
SSRS default value select all

    Question

  • In a new SSRS 2008 report, I want to be able to allow the user to select which report they  would like to see generated by selecting the report name from a dropdown list. This is a multi-valued parameter and the parameter name is called 'report'. I would like the default value to be for all 5 reports to be selected.

    All 5 reports will be on the 'main' report. There will be no subreports. Each report will have its own unique matrix and the matrix will be visibile based upon what is selected in the parameter called 'report'.

    My question is how can I make the 'default' value for the parameter called 'report' have all the reports selected?

     Normally to get all multivalued parameter values selected you create a dataset and run a query against a table. However in this case, there is no table to query. The user just selects what report(s) they want executed. 

    Thus how can I set the default value to select all the parameter values selected?



    Wednesday, June 18, 2014 8:57 PM

Answers

  • Hi wendy,

    After testing the issue in my environment, we can refer to the steps below to achieve your requirement.

    1. Right-click the multiple parameter ‘repot’ to open the Properties dialog box.
    2. Specify the values below in the Available values:
      Label: report1                                                 Value: report1
      Label: report2                                                 Value: report2
      Label: report3                                                 Value: report3
      Label: report4                                                 Value: report4
      Label: report5                                                 Value: report5
    3. Specify the values below as the Default Values:
      report1   report2   report3   report4   report5
    4. Right-click the ‘report1’ to open the Tablix Properties dialog box.
    5. Select Visibility in the left pane, type the expression below in the “Show or hide based on an expression” textbox:
      =iif(InStr(join(Parameters!report.Value,","),"report1")>0,false,true)
    6. Use the expressions below to control the visibility of the ‘report2’, ‘report3’, ‘report4’, ’report5’:
      =iif(InStr(join(Parameters!report.Value,","),"report2")>0,false,true)
      =iif(InStr(join(Parameters!report.Value,","),"report3")>0,false,true)
      =iif(InStr(join(Parameters!report.Value,","),"report4")>0,false,true)
      =iif(InStr(join(Parameters!report.Value,","),"report5")>0,false,true)

    If there are any other questions, please feel free to ask.

    Thanks,
    Katherine Xiong


    Katherine Xiong
    TechNet Community Support

    Thursday, June 19, 2014 9:03 AM
    Moderator