Rounding issue in XMLP Report output

Hi Friends,

I have a xmlp report which is giving excel output.

Opening Balance
-----------------
208,708,625.62
11,896,120.30
55,886,126.41
57,103,938.52
9,529,484.00
----------------
343,124,295.00 :Total
-------------------

When we sum all 5 values it shows 343,124,294.85 but it is rounded of why?

Opening balance is rounded in query. and total is summary column of that column.

In rtf used same format for both. #,##0.00

Query:

SELECT fc.segment2 asset_major_category,round(sum(a.cost),2) opening_balance ,round(sum(a.deprn_reserve),2) depreciation_reserve
FROM xxst_FA_RESERVEr_LEDGER_GT a
,FA_ADDITIONS b
,fa_categories fc
,(select max(b.request_id) req_id from xxst_fa_reserver_ledger_gt b) sq
where a.asset_id(+)=b.asset_id
and fc.category_id=b.asset_category_id(+)
and (a.request_id=sq.req_id or a.request_id is null)
and a.request_id(+)!=-1
group by fc.segment2
order by 1;

This will display opening_balance.
Then in rdf I took one summary column CS_OPENING_BALANCE
which is data type Number and source as opening_balance.

In rtf i took two form fields and put type as Number and format is #,##0.00 

Solution
------------

After trying lot of times Finally I find the mistake.

For CS_OPENING_COST width is 10. that's why it displays only 343,124,295.00

now i increased it to 20. now it showing 343,124,294.85


Hope this will help you...

Let me know if I am wrong...