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.

Answer 1

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.