Decimals treated as integers in CR and Lumira documents

[sylvain_dutilh]

Hello experts !

I'm having a weird issue with Crystal Reports Enterprise and Lumira 2.

Decimals are treated as integers... but not rounding them.

Let me explain.

We have for instance a measure, whose value is 1.234,5678 (integer part = 1234, decimal part = ,5678).

It is working perfectly fine on the Crystal or Lumira client.

ONLY ON THE LAUNCHPAD, it is shown in our documents as an integer value of 12.345.678, i.e the entire decimal number is considered an integer. it's causing errors if for instance our value is 1/3, then the displayed number is ridiculous.

The problem is not happening in Webi. Any idea?

I have been able to work around that by converting the numbers in a string, but it is a poor solution to a weird issue.

Our setup :

- BI Platform 4.2 SP5 patch 2

- Lumira 2.1 Sp0.

Thank you in advance for any help 🙂

[sylvain_dutilh · Accepted solution]

Hello again.

After a few experiments, we have managed to find the cause.

It was due to the fact that our Oracle client was set with American NLS, whereas our entire environment being in our local language (Icelandic).

For some reason it does not cause any issue with WebI but Lumira and CR seem to be a bit more susceptible.