Page 1 of 1

run parameter report without showing pram form

Posted: Wed Feb 07, 2007 1:31 am
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

Posted: Wed Feb 07, 2007 1:51 am
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.