nerdexam
Microsoft

70-466 · Question #1

You are designing a SQL Server Reporting Services (SSRS) report to display product names and their year-to-date (YTD) sales quantity. YTD sales quantity values are classified in three bands: High…

The correct answer is E. Use an expression for the Color property of the text box. To conditionally color text in an SSRS report, you must target the Color property of the text box using a conditional expression.

Build reports

Question

You are designing a SQL Server Reporting Services (SSRS) report to display product names and their year-to-date (YTD) sales quantity. YTD sales quantity values are classified in three bands: High Sales, Medium Sales and Low Sales. You add a table to the report. Then you define two columns based on the fields named ProductName and YTDSalesQuantity. You need to set the color of the product text to red, yellow, or blue, depending on the value of the YTD sales quantity values. What should you do?

Options

  • AUse an expression for the TextDecoration property of the text box.
  • BUse an expression for the Style property of the text box.
  • CAdd an indicator to the table.
  • DUse an expression for the Font property of the text box.
  • EUse an expression for the Color property of the text box.

How the community answered

(28 responses)
  • B
    4% (1)
  • D
    7% (2)
  • E
    89% (25)

Why each option

To conditionally color text in an SSRS report, you must target the Color property of the text box using a conditional expression.

AUse an expression for the TextDecoration property of the text box.

The TextDecoration property controls styling such as underline or strikethrough, not the color of text.

BUse an expression for the Style property of the text box.

Style is not a directly addressable color-controlling property on an SSRS text box; it refers to CSS-level style sheets in HTML rendering, not the font color.

CAdd an indicator to the table.

Indicators are graphical gauge or icon elements used to represent data states visually, not a mechanism for changing text color in a table cell.

DUse an expression for the Font property of the text box.

The Font property group controls font family, size, and weight, but color is a separate property outside the Font group.

EUse an expression for the Color property of the text box.Correct

The Color property of a text box in SSRS directly controls the foreground text color displayed in the rendered report. By assigning an expression such as =IIF(Fields!YTDSalesQuantity.Value > 1000, 'Red', IIF(Fields!YTDSalesQuantity.Value > 500, 'Yellow', 'Blue')), you can dynamically map each sales band to the appropriate color at runtime.

Concept tested: SSRS text box Color property conditional expressions

Source: https://learn.microsoft.com/en-us/sql/reporting-services/report-design/expression-examples-report-builder-and-ssrs

Topics

#conditional formatting#Color property#text box expressions#SSRS table

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 70-466 Practice