Apex Code Development You need to sign in to do that
Don't have an account?
DSimpson Conditional highlighting in reports
I don't know exactly where to post this, so here it is....
I woud like to have a custom object report that takes the value of a field (#red, #yellow, or #green) and highlights the background of that record in that colour, in the report. It's not a summary field; it's a field that would be set by the record owner. It's intended to make it easier for the execs to zoom in on which records are in trouble.
Any idea of how to do this?
Aaaah, how about this
I have heard that you could use images in formula fields, so if the value is Red use a red image ,... and so on
But, will it show in the report?? I'm not sure
All Answers
You will have to use a summary field...
Create a formula field of type Number, the formula would be like when (red is selected = 1, when green its 2, when yellow its 3)
Hide this field from the page layout, include it in the report and then you could do conditional highlighting...
I've not tried this, so not sure if it would work..
Let me know if it does
That was a great start, but it only colours the Sum of the number field in the report, not the field itself.
Aaaah, how about this
I have heard that you could use images in formula fields, so if the value is Red use a red image ,... and so on
But, will it show in the report?? I'm not sure
It worked fantastically! I created a field that used IF clauses to test the value of the Status field. Then I used the IMAGE function to display colour .jpg files that were stored in the Documents area, using H and W of 20 and 50. I put the field in the report, and it worked!
Thank you!
Click Show | Conditional Highlighting in report builder, then set the breakpoint values and their range colors