In order to allow me to focus on Consulting (click here) and Courses (click here), I continue to review all posts here in the Forums, but, in general, I'm only personally responding to posts that I mark as #AcumaticaTnT (click here). For Questions (click here), others may respond, or you can post over at Community.Acumatica.com (click here).
Questions Conditional Background color highlight
I am making an "Open Purchase Order Lines" report. Really not sure what to title/call it. Basically any line on the purchase order that is still open. This was easy using the =[POLine.BaseOpenQty] Value. I wanted to highlight (change background color) of the BaseOpenQty only if it is greater than 1. Is that easy to do without coding? see my picture for what I am trying to accomplish.
Ahh, Should have searched more thoroughly. So visible expressions are the answer
I received an answer over at community.acumatica.com
Here is what worked:
- 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
Attached screenshots for your reference.
Thanks for sharing. Also note that you can do this in a Generic Inquiry without overlapping fields.