Round Function to 2 decimal places does not work properly in Livereports

Isa_Hedemann

Hi

I use a statement

..

(SELECT ROUND(SUM(dversdata.datasize/ 1048576),2)   FROM dversdata where d.dataid = dversdata.docid ) as "Size (all versions) in MB"

...

to measure the size of a file.

The rounding to 2 decimal places works fine in Oracle SQL developer, but in the Livereport unfortunately only shows the MB and not the numbers behind the decimal point. (Therefore only 25  is listed, instead of 25,24 MB)

Does anybody know, why and how to change that in the Livereport? I have only found here in Knowledge base, that another person had the same problem, but did not found a solution in Knowledge base.

We use Livelink 9.7.1. Any helpful hint?

Thank you in advance

Isa

 

Colin_Schmidt

Use the TO_CHAR function.

Colin J. 

On Wed, Jan 28, 2015 at 11:49 AM, eLink Entry: Content Server LiveReports Forum <livereportsdiscussion@elinkkc.opentext.com> wrote:

Round Function to 2 decimal places does not work properly in Livereports

Posted byisa.hedemann@t-systems.com (Hedemann, Isa)On 01/28/2015 11:46 AM

HiI use a statement..(SELECT ROUND(SUM(dversdata.datasize/ 1048576),2)   FROM dversdata where d.dataid = dversdata.docid ) as "Size (all versions) in MB"...to measure the size of a file.The rounding to 2 decimal places works fine in Oracle SQL developer, but in the Livereport unfortunately only shows the MB and not the numbers behind the decimal point. (Therefore only 25  is listed, instead of 25,24 MB)Does anybody know, why and how to change that in the Livereport? I have only found here in Knowledge base, that another person had the same problem, but did not found a solution in Knowledge base.We use Livelink 9.7.1. Any helpful hint?Thank you in advanceIsa

---

[To post a comment, use the normal reply function]
Forum:	Content Server LiveReports Forum
Content Server:	Knowledge Center

This electronic message contains information from MeadWestvaco Corporation (mwv.com) or subsidiary companies, which may be confidential, privileged or otherwise protected from disclosure. The information is intended to be used solely by the recipient(s) named. If you are not an intended recipient, be aware that any review, disclosure, copying, distribution or use of this transmission or its contents is prohibited. If you have received this transmission in error, please notify MeadWestvaco immediately at postmaster@mwv.com.