Home » Developer & Programmer » Forms » export to excel (oracle 11g)
icon5.gif  export to excel [message #676837] Sun, 21 July 2019 00:57
younis
Messages: 1
Registered: July 2019
Junior Member
i want to be able to export my generated report from oracle form to excel

my current code to view on screen :

declare
P PARAMLIST;
begin
p := create_parameter_list('Temp');
add_parameter(p,'paramform',text_parameter,'NO');
add_parameter(p,'fromdate',text_parameter,:start_date);
add_parameter(p,'todate',text_parameter,:end_date);
add_parameter(p,'frommain',text_parameter,:from_main);
add_parameter(p,'tomain',text_parameter,:to_main);
add_parameter(p,'FROmsub',text_parameter,:from_group);
add_parameter(p,'TOsub',text_parameter,:to_group);
add_parameter(p,'fromcode',text_parameter,:from_item);
add_parameter(p,'tocode',text_parameter,:to_item);
add_parameter(p,'destype',text_parameter,'screen');
add_parameter(p,'ashop',text_parameter,:from_shop);
add_parameter(p,'zshop',text_parameter,:to_shop);


run_product(reports,'E:\ReportBulider\admin\netsold\netsold.rep',synchronous,runtime,filesystem,p);

IF NOT(ID_NULL(p)) then
destroy_parameter_list(p);
end if;
end;

hope any one can help

thanks
Previous Topic: Scrolling up the query data
Next Topic: Not able to connect with database from forms 6i but from forms 11g its connecting
Goto Forum:
  


Current Time: Thu Mar 28 14:20:51 CDT 2024