Conditional Formatting in Paginated Reports

Hi Anonymous ,

Please have a try.

=IIF(ID="Yes", "Red","Blue")

I have also found a blog about Conditional Formatting in Paginated Reports. Please refer to it.

Paginated Reports: Expressions, Conditional Formatting, and Subreports 

• You can also add conditional formatting to the report. We’ll add conditional formatting to the ID_Sales_Growth detail row. To do this, right-click the ID_Sales_Growth detail row -> select Textbox Properties -> select Font. This brings up the font size and coloring options. Since we’re going to only conditionally format the font color only, select the fx icon next the Color.

• The expression is set to Black by default. Let’s change it to =Iif(Fields!ID__Sales_Growth.Value< 0, “Red”, “Black”). The expression means that if the value of ID_Sales_Growth is less than zero, set the font color as red, otherwise, set the font color as black. Click OK and OK again.

Best Regards
Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.