OraFAQ Forum: Forms » export to excel

Home » Developer & Programmer » Forms » export to excel (oracle 11g)

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

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

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 22 00:49:03 CST 2024