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
run parameter report without showing pram form
-
- Posts: 615
- Joined: Mon Sep 18, 2006 1:32 am
- Location: United Arab Emirates
- Contact:
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.
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.
Who is online
Users browsing this forum: No registered users and 3 guests