on 10-30-2015 12:01 PM
I have an existing report and I want to use a formula to highlight the product description in a different color by checking the the 1st char of the product code for the control break.
Is this possible and if so can someone show me the code ?
Many thanks
Hi John,
Right click the field > Format field > Font tab > click the formula button beside Color and use this code:
If {product code}[1] = 'x' then
CrBlue
Else CRNoColor
Replace product code with its field name and 'x' with the value you're evaluating it for.
-Abhilash
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
10 | |
9 | |
9 | |
6 | |
6 | |
6 | |
5 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.