Skip to Content
0
Apr 29, 2020 at 05:51 AM

Decimal point/comma issue in Crystal Reports

1532 Views

I'm calling a function in the command protocol of Crystal Reports. It does not give the correct string, as the output is a varchar2. The problem is the decimal point handling.

Seems like Crystal Reports (2016 SP7 with OraClient12Home) does not use the regional (language/country) setting of the operating system (English UK, Windows 7).

When i use the following in the command:

SELECT TO_CHAR(5/2) FROM DUAL

it results: 2,5 while it needs to be 2.5.

I even set the 'Product Locale' and the ' Preferred Viewing Locale' to English in Crystal Reports, but nothing seems to help. The Oracle Database NLS setting is also correct (UK).

Kind regards,

Scubapro66.