CODEWITHSUNDEEP
reporting-servicesssrs-2008
JonathanWolfson
JonathanWolfson

Reputation: 861

Conditional Formatting in SQL Reporting Services 2008

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.

Upvotes: 5

Views: 9660

Answers (1)

Peter Radocchia
Peter Radocchia

Reputation: 11007

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.

Upvotes: 12

Related Questions