How to run the report from forms (using cgicmd.dat):

In Application server:

There will be a cgicmd.dat file in below path of oracle

C:\oracle\FRHome_1\reports\conf

Add below line in the cgicmd.dat file:

EMP_REP_KEY: USERID=USER5/USER5@TESTDB DESFORMAT=PDF DESTYPE=CACHE REPORT='C: \TEMP\REPORTS\EMPDEPT_REP.rdf%*

In Forms:

Call the Report using

web.show_document (:global.report_server_url||'?emp_rep_key&where_condition= where dept_no = 10’);

: GLOBAL.REPORT_SERVER_URL – report server URL

(Ex: http://122.22.222.332:port_no/Reports/rwservlet)