By using this website, you agree to our Terms of Use (click here)
is it possible in multiple column report to have font color in certain row have different color based on value (like negative value in red), so only in column where the value is negative
Yes. I wrote an article about it a while back and another colleague expanded a bit further too. Read through these and let me know if you need help.
https://www.cs3technology.com/cs3-technology-feed/acumatica-2019r1-offers-colors-on-inquiry-screen
These are regarding screens view, (if I understood well), I am asking when actually writing report if I have multiple columns and some have negative figures some positive numbers is it possible to have negative in red font or darker shade ,
Thank you
@nangel I think you would have to create two of the same fields and overlap them. Then use the Visible/VisibleExpr based on the criteria. Set one to be red in the styling and other to be default.
@travisl visible/visible exp what this means?
like if have 1 rows for one value, and than create additional 2 for <>0 and than hide based on result?
my problem is that i have multiple columns for different companies in one row so its not either or sitution
if I understood well what you are suggesting
if not would you have example
@nangel yes.
For example let’s do 2 companies.
Row 1 for Company 1: create all your text boxes. For Visible set to FALSE. For Visible Expr you would have =[Company] = ‘Company1’
Row 1 for Company 2: create another set of text boxes below Company1 boxes. For Visible set to FALSE. For Visible Expr you would have =[Company] = ‘Company2’
Now you would take all those text boxes for Company2 and move them over top of Company1.
it can get pretty complicated so what I do is I’ll expand the sections out, build all the text boxes and colors I want. Make sure it displays the correct ones I want with whatever I want it to display. Then I will move them on top of the other boxes. It’s easier to troubleshoot.
I can do some screenshots Monday if need be.
Online Members
