How to run report from form in form9iDS

[imranhad]

1-How to run report from form in form9iDS
2-From which site I can get max oracle pdf books
3-how to learn oracle apps(finacial) on cheap cast

[rminchrist]

For reports, use WEB.SHOW_DOCUMENT

[ahmadbilal]

by using web.show_document we are bound to put all parameter in address
Look @ code

DECLARE
report_para_list paramlist;
vc_url varchar2(1000);
BEGIN

IF :FDATE IS NULL THEN
SET_ALERT('Enter Value in From Date Field..','Alert');
GO_ITEM('FDATE');
RAISE FORM_TRIGGER_FAILURE;
END IF;

IF :TDATE IS NULL THEN
SET_ALERT('Enter Value in To Date Field..','Alert');
GO_ITEM('TDATE');
RAISE FORM_TRIGGER_FAILURE;
END IF;

IF ARTY IS NULL THEN
SET_ALERT('Enter Value in Party Name Field..','Alert');
GO_ITEM('PARTY');
RAISE FORM_TRIGGER_FAILURE;
END IF;


-----Look @ this Vc_url
vc_url:='http://lgs:8888/reports/rwservlet?serve ... RAMFORM=NO';
-----Look @ this Vc_url
WEB.SHOW_DOCUMENT(vc_url,'_blank');
NEW_FORM('CB_MAINFORM');


/* This is Forms 6i Code
report_para_list := Create_Parameter_list('TEMP');

Add_Parameter(report_para_list,'FDATE',Text_Parameter,TO_CHAR(TO_DATE(:FDATE,'DD-MON-YYYY'),'DDMMYYYY'));
Add_Parameter(report_para_list,'TDATE',Text_Parameter,TO_CHAR(TO_DATE(:TDATE,'DD-MON-YYYY'),'DDMMYYYY'));
Add_Parameter(report_para_list,'PARTY',Text_Parameter,:IID);
Add_Parameter(report_para_list, 'PARAMFORM', TEXT_PARAMETER, 'NO');

Run_Product(Reports,'HAWALA_PARTY_WISE',SYNCHRONOUS,RUNTIME,FILESYSTEM,report_para_list,NULL);
Destroy_Parameter_List(report_para_list);
NEW_FORM('CB_MAINFORM');
This is Forms 6i Code
*/

END;


How can i do more secure the report(adress not shown in address bar)