Skip to Content
0

Decimals treated as integers in CR and Lumira documents

Apr 11 at 05:28 PM

28

avatar image

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 :)

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Sylvain Dutilh Apr 13 at 04:43 PM
0

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.

Share
10 |10000 characters needed characters left characters exceeded