cancel
Showing results for 
Search instead for 
Did you mean: 

$ symbol is does not appear when field object is embedded in text object

Former Member
0 Kudos

There has been an uncanny issue where a $ symbol is not visible when field object is embedded in text object. The field object is embedded in text object in following format

"<Text1><Formula field (amount)><Text2>"

Ex: BeforeString $650.00 AfterString

Some of the findings related to this issue are:

  • Issue only persist if report is previewed in Crystal report viewer of VS 2010, i.e. the $ symbol does not display.
  • If same report of step 1 above is exported to .RPT format and opened in crystal designer then there is no issue as the $ symbol displays.
  • If report is directly exported to any format (without preview), then also there is no issue as the $ symbol is always visible.

We tried certain options but none of them worked out:

  • Fetch and display the currency symbol from current locale.
  • We tried looking for some property of text object using which we can set the currency format.
  • We tried most of the field object properties to set the currency format.
  • We installed Crystal Report Service Pack 11 to check if there is any fix by SAP.

We also faced similar issue where in the date formatting was lost when field object contains date instead of Amount, we couldn’t find any suitable solution for that issue as well.

Appreciate if someone can help.

Version details:

VS 2010 SP1

Crystal Report for Visual Studio: Support Pack 10 (v.13.0.10.1385 )

Crystal Report Designer 2013

Thanks in anticipation.

Prateek

Accepted Solutions (1)

Accepted Solutions (1)

0 Kudos

HI Prateek,

Not clear how the formula was created etc. Can you attach a report with saved data so I can have a look at it closely?

Thanks

Don

Former Member
0 Kudos

Hey Don,

Thanks for your reply, PFA the report with saved data. Kindly change the file extension from .txt to .rpt.

Regards,

Prateek

Answers (0)