Skip to Content
0
Former Member
Dec 05, 2008 at 02:36 PM

BO 5.1.8 - Decimal "zeroed" in reports though DB data contain decimal value

33 Views

Hello,

I've a problem with a report.

In my DB2 8.2 db I've a field defined as "DECIMAL" (that contains values with decimal of course...ex.: 100,48).

In my report, I get all the decimal of that field (and others) rounded like "xxx,00" (ex.: 100,00)

The values before de decimal are correct, but the values after the decimal are all ",00"

Within the data manager, I can see the values without decmals (ex: 100), so I weel understand it comes from that part, but how can I change this?

I've checked the Regional settings of my PC, all possible config in BO and in DB2 client but cannot find a clue for this.

Any suggestion would be warmly welcomed!!

Thanks a lot.