Display Checkmarks for Yes values in APEX report.

I have a table with an “active” flag column that stores either Y or N. In an APEX report, rather than displaying the literal letter in an APEX report, I want to display a green checkmark for Y, and a red X for N. To do this, I wrote a couple of custom classes utilizing the Font Awesome icon library.

I placed these two CSS classes into my global CSS file:

The values for the content attributes can be gotten from the Font Awesome cheatsheet (ignore the &#X characters).

facheck

In my APEX report ACTIVE column, I added the following HTML Expression:

htmlexpression

When the report runs, the HTML expression will return either check-Y or check-N, thus referencing the classes with the green check mark, or the red X.

report

 

 

 

 

 

Leave a Reply

Your email address will not be published. Required fields are marked *