Displaying a Checkmark

[sbcute]

CR XI Release 2, Oracle 10g
I need to display a checkmark based on certain conditions. I have tried inserting a 'checkmark' picture, but the background of the picture is not transparent and so on a shaded detail line, the box surrounding the checkmark displays.

I can solve my problem by displaying an 'X' when the condition is met, but the user would like a checkmark.

I know I must be making this more difficult than it needs to be, but I can't find a simple solution to this.

 

[ianoctdec]

Hello,

Create a formula
@CheckMark
chr(254)

Format with font Windings, and under Paragrah, for Text Interpretation, select HTML.


Dana

 

[sbcute]

Thank you ianoctdec,

I followed your example, however this gives me a checkmark inside of a box. I changed it to be chr(252) and I got just the checkmark. Thank you for heading me in the right direction...

Now, I have attempted to change the color from black to red in the 'format field...Font', but it still displays as black.

Any ideas how I can change the color?

 

[ianoctdec]

Hello,

You have to use HTML tags to set the color. Change the formula for checkmark as follows:

'<p style="color:red">' + chr(252) + '</p>'

Dana

 

[sbcute]

Thank you again...it works great!

I hate to add another question, but I will take the chance...

I am trying to suppress the checkmark based on certain conditions. I go to the 'common' tab and suppress based on this formula: ev_mg < 551 and ev_mt < 10
However, it doesn't suppress correctly. If I use only one condition it works ok, but adding the 'and' doesn't seem to work.

Is there a work around for this? Can suppression formulas be based on more than one condition?

 

[IanWaterman]

Would

ev_mg < 551 or ev_mt < 10

do what you want? With your existing formula both conditions have to be true.

Ian

 

[sbcute]

I get caught in a way to do something and I don't look outside the box. This happened to me again. I have figured this out...

Instead of 'suppressing' the checkmark, I am displaying the checkmark using the conditions in the formula (ev_mt >= 10 and ev_mg >= 551...

Thank you again for all your help...