Microsoft
70-448 · Question #205
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%…
The correct answer is C. =iif(avg(FieldsSTestScore.Value)>=.70 THEN "Green" , "Red"). See the full explanation below for the reasoning.
Question
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?
Options
- 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")
How the community answered
(35 responses)- A9% (3)
- B6% (2)
- C71% (25)
- D14% (5)
Community Discussion
No community discussion yet for this question.