Conditional Formatting in SQL Reporting Services 2008

Question

In SQL Reporting Services 2008, can you format a field conditionally? In Crystal Reports it is doable. I have a field which I want to be bold if another field is Y, and unbold if its value is N.

Accepted Answer

Use the FontWeight property of the field, and set it to an expression like this:

```
=iif(Fields!YourTestField.Value="Y","Bold","Default")
```

You can find FontWeight in the properties pane for the report item, or under Font -> Style -> Bold in the properties dialog (right click -> properties). Use the f(x) button to edit the formula.

Conditional Formatting in SQL Reporting Services 2008

Solution

Problem