70-448 · Question #72
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…
The correct answer is C. You should use the expression of "=Iif(Parameters! DislayValue.Value=0,False,True)". 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…
Question
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?
Options
- AYou should use the expression of =Iif(Parameters!rc: DislayValue.Value=10, True,True)"
- BYou should use the expression of =Iif(Parameters!rc: DislayValue.Value=10,False, False)"
- CYou should use the expression of "=Iif(Parameters! DislayValue.Value=0,False,True)"
- DYou should use the expression of =Iif(Parameters!rc:
How the community answered
(31 responses)- A6% (2)
- B3% (1)
- C77% (24)
- D13% (4)
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.
Topics
Community Discussion
No community discussion yet for this question.