SAP Knowledge Base Article - Public

1763526 - How to remove the space between a number and currency symbol in a formula in Crystal Reports


  • Space appears in between a number and its currency symbol.
  • Number field converted to text format in a formula cannot be customized to avoid the space between the field and currency.


  • Crystal Reports 2008.
  • Crystal Reports 2011.

Reproducing the Issue

  1. In Field explorer >> Right click on formula >> Add >> name it as SAP test >> ok
  2. Type the following formula. Note following formula is created using Xtreme sample database as a datasource
  3. ToText(Sum{Customer.Last Year’s Sales}, {Customer.Country}),’######0.00’)
  4. Place this formula on the Report canvas.
  5. Refresh the report. The formula will populate the values as represented in the image given below.

 sap test.JPG


Make the following changes to the formula and replace it on the Report canvas.

Replace(ToText(Sum{Customer.Last Year’s Sales}, {Customer.Country}),’######0.00’), " ", "")

Now the space between the currency symbol and number field is removed by using the Replace function and replacing the space. Refer the image given below.

sap test2.JPG


Number, formatting, formula, replace , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , How To


Crystal Reports 2008 V0 ; Crystal Reports 2008 V1 ; SAP Crystal Reports 2011


sap test.JPG
sap test2.JPG