You are developing a SQL Server 2008 Reporting Services (SSRS) report.
The organization requires a drilldown report that color coordinates the values of students’
test scores. All average scores 70% or higher should have a green background. All lower
average scores should have a red background.
You need to enable this functionality.
Which expression should you use?
A.
=iif(Fields!TestScore.Value >=.70, Green, Red)
B.
=iif(Fields!TestScore.Value >=.70 THEN “Green” ELSE “Red”)
C.
=iif(avg(FieldsSTestScore.Value)>=.70 THEN “Green” , “Red”)
D.
=iif(avg(Fields!TestScore.Value)>=.70,”Green”,”Red”)