Home » Developer & Programmer » Reports & Discoverer » How Format upto 2 decimal places by put_cell
How Format upto 2 decimal places by put_cell [message #436977] Wed, 30 December 2009 01:10 Go to next message
sunil.madnani
Messages: 36
Registered: March 2007
Location: BHILAI
Member
Dear Gurus,

i am using rpt2xls.put_cell(1,:amount,null,null,0,null,null,null,-4108);

for converting into excel.

But i am getting output as 100,200,300 e.g
desired output is 100.00,200.00

for this what i have to do please give me suggession or possible codes.

Note: I have already made format mask in pdf as 999999.99
but in excel it is not comming as required.

regards:
Sunil Madnani
Urgent : format number upto 2 decimal places using ole2.put_cell [message #437129 is a reply to message #436977] Thu, 31 December 2009 03:15 Go to previous message
sunil.madnani
Messages: 36
Registered: March 2007
Location: BHILAI
Member
Dear all,

i want to format a field which is of number type. It should be dumped in excel as formatted up to 2 decimal places .

i am using rpt2xls.put_cell(1,:amount,null,null,0,null,null,null,-4108);

current output :100
expected output :100.00

It is very urgent please revert back with example or sample code.

Note: I am attaching a RDF for exapmple. In this i want F_trnsprt_hndlg_chrg to be formatted upto 2 decimal places in excel.

Regards:
Sunil Madnani

Previous Topic: How to use multiple clauses using Lexical Parameter (merged 2)
Next Topic: report's strange sign
Goto Forum:
  


Current Time: Thu Mar 28 14:38:36 CDT 2024