In a report I want to highlight/ change the background color if the value is greater than 1. I understand i need to put two fields on top of one another. One with the default state and one with the changed state. my questions are as follows:
Do I use visible expressions for each field? Can you help me write the expression?
I am leaning towards an IIF, but that is as far as i got.
Best answer by Naveen BogaView original
@richard77 Long back I also worked on the similar kind of requirement. Please find the details below and hope this helps!!
Visible Expression for Backgroud Colored Field => [POLine.BaseOpenQty] > 1
Visible Expression for Non - Backgroud Colored Field => [POLine.BaseOpenQty] <= 1
Attached screenshots for your reference.
@ray20 Hope you are doing well!
I’m glad that I helped you! :)