run parameter report without showing pram form

To discuss Oracle Forms & Reports related technical issues.
Post Reply
patelwork
Posts: 18
Joined: Thu Jan 25, 2007 1:55 am
Location: Pakistan

run parameter report without showing pram form

Post by patelwork »

hi,

i have a report with parameters i want to passed it thru form and i already written the codes..the problem is when i run the report it's shows the parameter form of report i don't want to show it...

how can i do it??

thanks
ahmadbilal
Posts: 615
Joined: Mon Sep 18, 2006 1:32 am
Location: United Arab Emirates
Contact:

Post by ahmadbilal »

which code you are passing to report,try this


DECLARE
report_para_list paramlist;
BEGIN


IF :INAME IS NULL THEN
SET_ALERT('Enter Value in Item Name Field..','Alert');
GO_ITEM('INAME');
RAISE FORM_TRIGGER_FAILURE;
END IF;

report_para_list := Create_Parameter_list('TEMP');

Add_Parameter(report_para_list,'CD',Text_Parameter,:IID);
Add_Parameter(report_para_list, 'PARAMFORM', TEXT_PARAMETER, 'NO');

Run_Product(Reports,'CHART_OF_PARTYCITY.rep',SYNCHRONOUS,RUNTIME,FILESYSTEM,report_para_list,NULL);
Destroy_Parameter_List(report_para_list);
NEW_FORM('MAINFORM');


END;



let us know if still prblem exists.
Post Reply

Who is online

Users browsing this forum: No registered users and 3 guests