You are designing a Microsoft SQL Server 2005 Reporting Services (SSRS) report. The report contains financial data. An input parameter named TargetMfr is present in the report. When a value in the Machine_Mfr field matches the selected value in the input parameter, the color of the output in a column is red. Otherwise, the color of the output is green. You need to set the TextBox that contains the color property of the Machine_Mfr field to the appropriate expression. Which expression should you use?
A.
=Iif(Fields!Machine_Mfr = Parameters!rc:TargetMfr.Value,”Red”,”Green”)
B.
=Iif(Fields!Machine_Mfr.Value = Parameters!TargetMfr.Value,”Red”,”Green”)
C.
=Iif(InScope(Machine_Mfr),”Red”,”Green”)
D.
=Iif(InScope(TargetMfr),”Red”,”Green”)