Livereport does not seem to support decimal numbers

adarsh_lobo_(adarsh.lobo@shell.com_(Delete)_112626

Hi,I notice Livereport does not seem to print decimal points. For example, if I create an Auto Livereport with SQL command “select 1.33 from dual”,Only the value 1 will be returned, instead of 1.33Any way to overcome this please?Thanks,Adarsh

Find more posts tagged with

Comments

Bhupinder_Singh

Message from Bhupinder Singh <bsingh@opentext.com> via eLink

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">eLink

This is a known bug, and a workaround is to use a string conversion:

Bug # LPAD-284

LiveReports don't return real numbers. Results are truncated.

Workaround example below:

If I use this SQL statement: select 5.55 "Test" from dual
....then the Livereport returns only: 5

If I convert the number to a string first, like this, it works fine: select to_char(5.55, '9,999.99') "Test" from dual
....and the LiveReport returns: 5.55

- Bhupinder

----------------------------------------------
Bhupinder Singh, B.Math, B.Ed.
Senior Systems Analyst, Information Technology
Open Text, Waterloo, Ontario, Canada
----------------------------------------------

From: eLink Discussion: Open Text Live Reports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Thursday, October 22, 2009 6:01 AM
To: eLink Recipient
Subject: Livereport does not seem to support decimal numbers

Livereport does not seem to support decimal numbers

Posted by adarshlobo (lobo, adarsh) on 2009/10/22 05:56

Hi,

I notice Livereport does not seem to print decimal points.

For example, if I create an Auto Livereport with SQL command “select 1.33 from dual”,

Only the value 1 will be returned, instead of 1.33

Any way to overcome this please?

Thanks,
Adarsh

adarsh_lobo_(adarsh.lobo@shell.com_(Delete)_112626

Message from <Adarsh.Lobo@shell.com> via eLink

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">eLink

Thank You Bhupinder!

-----Original Message-----
From: eLink Discussion: Open Text Live Reports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Thursday, October 22, 2009 6:30 PM
To: eLink Recipient
Subject: RE Livereport does not seem to support decimal numbers

RE Livereport does not seem to support decimal numbers Posted by bsingh (Singh, Bhupinder) on 2009/10/22 08:59
In reply to: Livereport does not seem to support decimal numbers Posted by adarshlobo (lobo, adarsh) on 2009/10/22 05:56

Message from Bhupinder Singh <bsingh@opentext.com> via eLink

This is a known bug, and a workaround is to use a string conversion: Bug # LPAD-284 LiveReports don't return real numbers. Results are truncated. Workaround example below: If I use this SQL statement: select 5.55 "Test" from dual
....then the Livereport returns only: 5

If I convert the number to a string first, like this, it works fine: select to_char(5.55, '9,999.99') "Test" from dual
....and the LiveReport returns: 5.55 - Bhupinder

----------------------------------------------
Bhupinder Singh, B.Math, B.Ed.
Senior Systems Analyst, Information Technology
Open Text, Waterloo, Ontario, Canada
----------------------------------------------

From: eLink Discussion: Open Text Live Reports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Thursday, October 22, 2009 6:01 AM
To: eLink Recipient
Subject: Livereport does not seem to support decimal numbers

Livereport does not seem to support decimal numbers Posted by adarshlobo (lobo, adarsh) on 2009/10/22 05:56

Hi,

I notice Livereport does not seem to print decimal points.

For example, if I create an Auto Livereport with SQL command “select 1.33 from dual”,

Only the value 1 will be returned, instead of 1.33

Any way to overcome this please?

Thanks,
Adarsh