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.