I have a couple of things I need to highlight based on a couple of criterias. What is the word you use to highlight a field? Say, if I wanted it to be highlighted yellow.
you can go into the format field section on the fields you want and under the border tab you can set the background color of the field, it has a condition box also so you can put your criterias in there
I need this highlighted different colors and the format wants numbers only.
If left({equipnum},2)="MD" and {duration}>"00:02:00" then highlight yellow {equipment} else if left({equipnum},2)="MA" and {duration}>"00:04:00" then highlight red {equipment} else black {equipment}
Find the {equipment} field on the report.
Right-click on it and select "Format Field".
Click on the "Font" tab.
Click the X-2 button beside color.
Enter the following code:
Code:
If left({equipnum},2)="MD" and {duration}>"00:02:00"
then cryellow
else if left({equipnum},2)="MA" and {duration}>"00:04:00" then highlight crred
else crblack
Make sure you specify the real field names for {equipment} and {duration} in the format {table.field}. You'll be able to double-click the fields from the Field List area of the Formula Editor.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.