Skip to Content

Decimals treated as integers in CR and Lumira documents

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Apr 13, 2018 at 04:43 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded