Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Conditional Formatting in Paginated Reports

I want to conidtional format cells within a paginated report that highlights the cell "RED" if it has an associated ID that says YES, if no then leave as is.  For example within the picture belwo the...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Anonymous ,

Please refer to the topic to see if it helps you.

Conditional Formatting of Fields in Paginated Reports 

=IIF(Me.Value="Ongoing Company Contact", "Green",IIF(Me.Value="On-Hold", "Red",IIF(Me.Value="In-Progress", "Yellow", "Black")))

 

More details: Conditional Formatting for SQL Server Reporting Services Reports 

  • In the formula window, we will put the following formula:     
=IIf(Fields!pctFree.Value<0.2,"Bold","Default")

We use the IIf function that returns 2 values depending on the evaluation of an expression. In this case, our expression is to evaluate if the free space of a drive is under 20%. If true, it will return “Bold”, if false, it will keep the “Default” value:

 

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.