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

SAP Knowledge Base Article - Public

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

Symptom

  • 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.

Environment

  • 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

Resolution

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

Keywords

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

Product

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

Attachments

sap test.JPG
sap test2.JPG