BI Publisher (MOSC)

MOSC Banner

< fsg:RptCell > Work with real numbers

edited Jun 17, 2017 5:00AM in BI Publisher (MOSC) 1 commentAnswered

Hi there

I'm working in a Excel XML publisher report, in the ouput file I get numbers stored as text, I found that you can work with raw amounts but I don't know how to code it in the data definition that I have.

Here's a sample of mi data definition code:

select to_number(round(sum(aida.amount),2)) IVA_TRX,

Here's the xml output:

<iva_trx>1600</iva_trx>

I found in a FSG report this raw amounts cases:

Xml output:

<fsg:RptCell ColCnt="c1004" RealNum="547031.940000">547,031.94</fsg:RptCell>

I want to apply this to my xml data definition but I don't know how to modify the code or mask...I want to code the data definition in order that my current xml output: <iva_trx>1600</iva_trx> looks like this <fsg:RptCell ColCnt="c1004" RealNum="547031.940000">547,031.94</fsg:RptCell> and the data stored in the excel template will be numbers as raw amounts.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center