Wednesday, March 26, 2014

Setting Reporting Parameter Properties based on Previous Selected Value

Hi Zionlite,


To achieve your requirement, we can refer to the following method:



  1. Add the expression as the second parameter default value:

    =IIF(Parameters!ReportParameter1.Value=TRUE,FALSE,NOTHING)

  2. Add the expression as the third parameter default value:

    =IIF(Parameters!ReportParameter1.Value=false and Parameters!ReportParameter2.Value=false,TRUE,FALSE)




The following screenshot is for your reference:




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


Thanks,

Katherine Xiong




Katherine Xiong

TechNet Community Support



No comments:

Post a Comment