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:
=[POLine.BaseOpenQty]
=[POLine.BaseOpenQty]
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 Boga
Hi @richard77 Long back I also worked on the similar kind of requirement. Please find the details below and hope this helps!!
As you said, we need to have two fields. One for Color one and other one is default field.
For the Colored one, you can provide the Background color
Yes, we need to provide the Visible expression for the 2 fields like below
Visible Expression for Backgroud Colored Field => [POLine.BaseOpenQty] > 1
Visible Expression for Non - Backgroud Colored Field => [POLine.BaseOpenQty] <= 1
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.