3288156 - Currency Symbols Not Fixed to a Side in Crystal Reports for Enterprise

• Formula object with custom Format and "Fixed Symbol" setting
• Custom formula that returns crFixedCurrencySymbol is not fixed 
• Instead, the symbol moves around depending on the value length

• SAP Crystal Reports for Enterprise 4.2 
• SAP Crystal Reports for Enterprise 4.3

1. Create a report in Crystal Reports for Enterprise.
2. Add a numerical record, or a formula which results in a number, to the body of the report.
3. Right click the field and choose "Format Result Object Element..." or "Format Formula Element..."
4. Expand the Format tab on the left and choose Currency.
5. In "Symbol Format", choose Fixed. Then, click the "fx" to the right to choose a Conditional Formula.
6. Return crFixedCurrencySymbol.
7. When checking the Page view of the report, the field's currency symbol is not fixed and instead shifts depending on the value length.
8. Export the report to PDF and upon opening, see that the currency is also not fixed there.

Issue is a product defect.

Workaround:

1. Edit your fields with the problematic currency symbol to have no currency symbol anymore (just a number).
2. If you want your currency symbol to only exist on certain lines, create a new Formula.
   1. In the formula, add logic for when the dollar sign should appear and return your currency symbol as a string accordingly (ex "$").
3. If you want the currency symbol to show up for every record (you don't require added logic to specify when the symbol should appear), just create a new text object with your currency symbol in it.
4. Place your new formula or text object next to the number value.
5. Now, your currency will always be fixed.

cr4e, cr, dollar, left, right, justified , KBA , BI-RA-CRE , Crystal Reports for Enterprise , Known Error