Skip to Content
0
Former Member
Aug 11, 2015 at 11:09 AM

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

78 Views

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,15 12.15 12.96 12,96 12.96 15.77 15,77 15.77 AK78 AK78 AK78 OR001 OR001 OR001 RES RES RES 99.01 99,01 99.01 14.03 14,03 14.03 15,96 15,96 15.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