< fsg:RptCell > Work with real numbers
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.