Add a Smiley Face Rating Icon to a Report
Add a Smiley Face Rating Icon to a Report 2 August 2010, 3:40 pm You can easily add a rating icon, such as smiley faces to communicate at a glance in a variety of ways. Building on the checkbox article posted earlier, we’ll look at how to use Wingdings to quickly add a rating icon based on a character: Create a new formula, with an appropriate name (for example, RatingIcon) that defines what character code to show, depending on the value of the field. In our example, we want a smiley face if the value is above 90%, a neutral face if the value is above 80% but less than 90%, and a frowning face if the value is 80% or lower. if {@Percentage}>90 then chr(74) else if {@Percentage}>80 then chr(75) else chr(76) Continue reading ‘Add a Smiley Face Rating Icon to a Report’ » Filed under Format . Comment