topic Re: Conditional Formatting of Fields in Paginated Reports in Report Server

Conditional Formatting of Fields in Paginated Reports

Anonymous — Wed, 30 Dec 2020 14:02:32 GMT

Good Day,

I have created a Power BI Paginated Report using Report Builder. One of the fields that is in my report needs to have color associated with the TEXT in the field. So for example - if the field says "ON HOLD" the FONT Color needs to be RED. Is this possible at all with Paginated Reports? I've searched for videos, etc., but can't find anything specific. Any suggestions or links to documentation that I could read?

Thanks

Re: Conditional Formatting of Fields in Paginated Reports

Anonymous — Wed, 30 Dec 2020 15:58:22 GMT

Thank you all - I figured it out by doing nested IF statements in the Background field. Here is what I used in case there are others out there trying to figure this out. Background Color Expression: =IIF(Me.Value="Ongoing Company Contact", "Green",IIF(Me.Value="On-Hold", "Red",IIF(Me.Value="In-Progress", "Yellow", "Black")))

Re: Conditional Formatting of Fields in Paginated Reports

Anonymous — Fri, 01 Jan 2021 05:27:56 GMT

Anonymous

Glad you fixed it, and Thanks for sharing, people with same question could find the solution quickly.

Paul Zheng _ Community Support Team