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.

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.

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.

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