OraFAQ Forum: Reports & Discoverer

Home » Developer & Programmer » Reports & Discoverer » character in excel (oracle form6i,database 9i ,unix os)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

character in excel [message #502470]

Wed, 06 April 2011 09:50

hisham99
Messages: 106
Registered: October 2008
Location: united arab emirates

Senior Member

i create report containe employee bank account and i have to converted to excel using button in the report page
table is like this
(empno number(8),
bank_acc char(23),
salary number(13,2))
it work fine but my problem is most of the account start with zero like (000000546789) in report its appear okey but when i converted to excel its appear like this(2.36098E+11)
im using procedure RPT2XLS

this is the code i used as format trigger in the field of bank_acc
RPT2XLS.put_cell(1, acc1 ,FontColor => 1, FontSize => 10);

[EDITED by LF: disabled smilies in this message]

[Updated on: Wed, 06 April 2011 13:34] by Moderator

Report message to a moderator

Re: character in excel [message #502492 is a reply to message #502470]

Wed, 06 April 2011 13:36

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Are you sure that 000000546789 became 2.36098E+11?

Nevertheless: can you specify (in RPT2XLS) that this column should be formatted as (MS Excel) "Text"?

Report message to a moderator

Re: character in excel [message #502520 is a reply to message #502492]

Thu, 07 April 2011 00:04

hisham99
Messages: 106
Registered: October 2008
Location: united arab emirates

Senior Member

i attached the PACKAGE RPT2XLS
thanks for your help

Attachment: RPT2XLS.txt
(Size: 5.58KB, Downloaded 2144 times)

Report message to a moderator

Re: character in excel [message #502522 is a reply to message #502520]

Thu, 07 April 2011 00:14

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I never used it (and there's no documentation attached) so ... no idea. Can't search the net at the moment.

What does PUT_CELL's FORMAT parameter do? Can you use it for that purpose?

What is ACC1 you used while calling RPT2XLS? What is its datatype?

Report message to a moderator

Re: character in excel [message #502614 is a reply to message #502522]

Thu, 07 April 2011 10:18

hisham99
Messages: 106
Registered: October 2008
Location: united arab emirates

Senior Member

can you show me an example from your side

Report message to a moderator

Re: character in excel [message #502644 is a reply to message #502614]

Thu, 07 April 2011 15:17

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

As I said: I never used it and I don't have documentation that explains how to use RPT2XLS.

Report message to a moderator

Re: character in excel [message #503034 is a reply to message #502644]

Tue, 12 April 2011 07:52

hisham99
Messages: 106
Registered: October 2008
Location: united arab emirates

Senior Member

i solve my propblem thanks

Report message to a moderator

Re: character in excel [message #503056 is a reply to message #503034]

Tue, 12 April 2011 11:00

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Would you mind to share the knowledge?

Report message to a moderator

Re: character in excel [message #503856 is a reply to message #503056]

Wed, 20 April 2011 02:23

hisham99
Messages: 106
Registered: October 2008
Location: united arab emirates

Senior Member

to lead zero but =

RPT2XLS.put_cell(1,'="'||acc1||'"',FontColor => 1, FontSize => 10);

Report message to a moderator

Previous Topic:	Oracle 10g report printing on Line Matrix printer
Next Topic:	how to run report from remote report server

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 01 03:12:19 CST 2025