You are developing a SQL Server 2008 Reporting Services (SSRS) report for Company.com.
The parameter called DislayValue you design for the report will display below (it has some properties)
Data Type:
StringPrompt:
Display Number
Available Values: queried with the following Label/Value pairs:oYes/10oNo/1
Default Values: Empty
You could operate the visibility of the column by the parameter.
You should use the proper expression to meet this situation.
Which is the correct answer?
A.
You should use the expression of =Iif(Parameters!rc: DislayValue.Value=10, True,True)”
B.
You should use the expression of =Iif(Parameters!rc: DislayValue.Value=10,False, False)”
C.
You should use the expression of “=Iif(Parameters! DislayValue.Value=0,False,True)”
D.
You should use the expression of =Iif(Parameters!rc: DislayValue.Value=10,False,True)”
Explanation:
IIf(expr, truepart, falsepart)All three parameters are required:
expr is the expression that is to be evaluated.
truepart defines what the IIf function returns if the evaluation of expr returns true.
falsepart defines what the IIf function returns if the evaluation of expr returns false.