Crystal Reports – How to format number as percentage

by

The following steps describe how to format a number so that it looks like a percentage.

The obvious thing to point out is that there is no true ‘percentage’ value in Crystal Reports – but you can take a number and format it so that it ends with a percent symbol. That is, 55.23 displayed as 55.23 %.

First – if your value is currently a decimal, e.g. 0.5523, you will need to times is by 100 to shift the decimal place to 55.23.

To do this,

  1. Right-click on formula field and give it a name, e.g. percent_value
  2. crystalreports-booleantick2
  3. add the field and times by 100. For example
{table.value} * 100

Now that the value has the correct decimal place you can add the field (or newly created formula field) to the report and apply the formatting.

  1. Right-click on the field and then click on ‘Format Field’
  2. On the ‘Number’ tab click on the ‘Customize’ button
  3. crystalreports-formatnumberaspercent1
  4. Open the ‘Currency Symbol’ tab
  5. Tick ‘Enable Currency Symbol’
  6. Change ‘Currency Symbol’ to %
  7. Change ‘Position’ to -123%
  8. crystalreports-formatnumberaspercent2
  9. Click ‘OK’ and ‘OK’ again to save the changes.
  10. You now have a number formatted as a percent.
  11. crystalreports-formatnumberaspercent3