1504294 - Currency Symbol changed when view Crystal Reports in InfoView

SAP Knowledge Base Article - Public

1504294 - Currency Symbol changed when view Crystal Reports in InfoView

Symptom

  • The symbol of currency field defined as customized Currency format changed to the symbol follow by InfoView preference.
    • For example, Currency format "$0.00" in Crystal Reports 2008, shown as "¥0" in InfoView which preference is set to Japanese locale.

Environment

  • SAP Crystal Reports 2008
  • SAP BusinessObjects Enterprise XI 3.1 (BOE XI3.1)

Reproducing the Issue

  1. Create a CR report by Crystal Reports 2008 with some data source which currency field is included.
  2. Create a new Formula field, which combines the currency field and a string. like "CUR" + currency field.
  3. Drag&Drop the Formula field into the Detail section.
  4. Click file -> Options -> Fields -> Currency.
  5. Choose Number tab.
  6. Click Customize button.
  7. Choose Number tab.
  8. Set as Decimals 1.00, Symbol as $.
  9. Save the CR report and export it to BOE system.
  10. Logon InfoView.
  11. Change the Preference -> Locale to Japanese.
  12. View the CR report from InfoView.

Resolution

  • Devide the combined Formula field into two fields.
    1. Create one Formula Filed: "CUR"  
    2. Create another Formula Filed: currency field
    3. Drag the two field into CR report.

Keywords

mark, decimal, system default, browser, unit , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Problem

Product

Crystal Reports 2008 V0 ; Crystal Reports 2008 V1