Saturday, March 27, 2021

Return the checkmark symbol from a formula

 Hi....this comes from the Crystal Knowledgebase artical C2010279

********************************
4. Create a formula similar to the following:
// (xxx) represents the character you want to display
CHR(xxx)
For example:
CHR(254) displays a check box with a check mark in the report and CHR(252) only displays the checkmark without the box in the report.
// CHR(254) - displays a box with a check mark
// CHR(253) - displays a box with an X
// CHR(111) - displays an empty box
// CHR(252) - displays a check mark only
// CHR(251) - displays an X only
5. Insert the formula into the report.
6. Right-click the @CheckBox formula field, and select 'Font'.
7. From 'Font', select 'Wingdings', and click 'OK'.

If ({X_BD_MUL_COMP_REP.MULTI_COM}='FALSE') THEN
Chr(251)
ELSE
Chr(252)


IF({Customers.Registered}='Yes')THEN
Chr(254)
ELSE
Chr(168)

No comments:

Post a Comment

To generate a PDF using JavaScript in Oracle APEX from a collection

  To generate a PDF using JavaScript in Oracle APEX from a collection, you can follow these steps: 1. Create a button or link on your APEX p...