SSRS change the color on part of an expression based on conditional logic

Question

How do change part of the string's color in SSRS based on conditional logic.

This is what the expression currently looks like:

=" Total Amount Due: " & FormatCurrency(ReportItems!GrandTotal.Value)

What I want to do is something like this iif(ReportItems!GrandTotal.Value >= 0, "red", "black") but we only want to change the color of the GrandTotal field rather then the complete string.

I understand how to change color based on conditional logic, but I can't figure out how to change color based on conditional logic only for part of the expression

Answer 1

You can try to put the static text outside of your placeholder expression, but in the same textbox. You can then remove the "Total Amount Due" from your expression and you can set your conditional logic to the entire expression, which will only have the value.