OraFAQ Forum: Reports & Discoverer

Home » Developer & Programmer » Reports & Discoverer » Report to Execl (Reports 6i)

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

Report to Execl [message #305935]

Wed, 12 March 2008 06:26

Chandrabhushan
Messages: 4
Registered: March 2008
Location: Hyderabad

Junior Member

Dear All,

I am new to oracle reports, i want to transfer report to excel
i put a button in the report and i used rpt2xls package in button action.
I run the report in runtime preview then i got an error like

Rep-1401:'u_1button action':Fatal PL/SQL error occured.
ORA-06502:PL/SQL: numeric or value error

Excel work book is opened when we click the button in the report, but no data transferd to excel sheet.

this is the problem i got. Please suggest me in this regard

Regards,
Bhushan.

Report message to a moderator

Re: Report to Execl [message #306016 is a reply to message #305935]

Wed, 12 March 2008 10:07

doss_arun
Messages: 10
Registered: February 2008
Location: iselin, new jersey

Junior Member

that error is for datatype and width problem. check it

Report message to a moderator

Re: Report to Execl [message #306050 is a reply to message #305935]

Wed, 12 March 2008 12:14

gnod
Messages: 19
Registered: December 2007

Junior Member

Chandrabhushan wrote on Wed, 12 March 2008 06:26

Excel work book is opened when we click the button in the report, but no data transferd to excel sheet.

you're having a problem with the "RPT2XLS.put_cell" procedure.
i encounter that error when i try to use the word "CENTER" for Align instead i use the numeric value "-4108".

RPT2XLS(1, :P_CODE, Align => -4108);

Report message to a moderator

Re: Report to Execl [message #307203 is a reply to message #306016]

Tue, 18 March 2008 02:25

Chandrabhushan
Messages: 4
Registered: March 2008
Location: Hyderabad

Junior Member

Dear Arun,

I cleared that previous problem but i got a new problem
ie i get the hedder repeat in the excel sheet along with
the data when i go to next pages of the report
i want to print the headder only in first row of the excel
sheet.

Please clarify it.

Thanks and regards
Bhushan.

Report message to a moderator

Re: Report to Execl [message #307206 is a reply to message #306050]

Tue, 18 March 2008 02:28

Chandrabhushan
Messages: 4
Registered: March 2008
Location: Hyderabad

Junior Member

Dear Gnod,

I cleared that previous problem but i got a new problem
ie i get the hedder repeat in the excel sheet along with
the data when i go to next pages of the report
i want to print the headder only in first row of the excel
sheet.

Please clarify it.

Thanks and regards
Bhushan.

Report message to a moderator

Re: Report to Execl [message #307820 is a reply to message #307206]

Thu, 20 March 2008 01:37

gnod
Messages: 19
Registered: December 2007

Junior Member

because you are using a repeating frame. i use the RPT2XLS procedure in 1 page only. i still haven't solved exporting multi-page of report in excel..

Report message to a moderator

Re: Report to Execl [message #314701 is a reply to message #307206]

Thu, 17 April 2008 09:23

blaze
Messages: 5
Registered: April 2008

Junior Member

I solved it like that:

srw.get_page_num(l_page_number); 
if l_page_number = 1 then 
  RPT2XLS.put_cell....
end if;

Report message to a moderator

Previous Topic:	Join that will do both inner and outer
Next Topic:	how to hide an object on printing?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 15 13:45:41 CDT 2024