Home » Developer & Programmer » Reports & Discoverer » Report to Execl (Reports 6i)
Report to Execl [message #305935] Wed, 12 March 2008 06:26 Go to next message
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.
icon3.gif  Re: Report to Execl [message #306016 is a reply to message #305935] Wed, 12 March 2008 10:07 Go to previous messageGo to next message
doss_arun
Messages: 10
Registered: February 2008
Location: iselin, new jersey
Junior Member

that error is for datatype and width problem. check it
Re: Report to Execl [message #306050 is a reply to message #305935] Wed, 12 March 2008 12:14 Go to previous messageGo to next message
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);

Re: Report to Execl [message #307203 is a reply to message #306016] Tue, 18 March 2008 02:25 Go to previous messageGo to next message
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.
Re: Report to Execl [message #307206 is a reply to message #306050] Tue, 18 March 2008 02:28 Go to previous messageGo to next message
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.
Re: Report to Execl [message #307820 is a reply to message #307206] Thu, 20 March 2008 01:37 Go to previous messageGo to next message
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..
Re: Report to Execl [message #314701 is a reply to message #307206] Thu, 17 April 2008 09:23 Go to previous message
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;
Previous Topic: Join that will do both inner and outer
Next Topic: how to hide an object on printing?
Goto Forum:
  


Current Time: Sat Dec 10 04:55:16 CST 2016

Total time taken to generate the page: 0.05183 seconds