Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How to find the system decimal separator in crystal report9.0

Hi all,

I am using crystal report 9.0 version.

In the data base field "ResultVal" is in nvarchar datatype. Data value of ResultVal column some of having numerical results and some of the Alpha numeric data and some of having only alpha data.

Now, I wanted to display the "Resultval" field in crystal report and If "ResultVal" field contains only numeric(with decimal), then decimal separator should be printed as per system decimal separator.

Example Data:

ResultVal Output in report, if decimal separator is ","Output in report, if decimal separator is "."
12.15 12,1512.15
12.96 12,9612.96
15.77 15,7715.77
AK78 AK78AK78
OR001 OR001OR001
RES RESRES
99.01 99,0199.01
14.03 14,0314.03
15,96 15,9615.96
10,00 10,00

10.00

How to update the decimal separator in system:

Control panel >> Region and language >> formats TAB >>  Click Additional settings >> Decimal sysmbol >> Enter  ","

Please help me how to resolve the problem.

Thanks in advance..

Sankar

Tags:

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question