RE: What is the process to call a report from a form o...
Dear Friend Please look at this probably this will help you out.To run a report from within a form you must use the dedicated report integration built-in RUN_REPORT_OBJECT. If you want the call the report without parameter form you need create a parameter list before using the RUN_REPORT_OBJECT using ADD_PARAMETER built-in. Once the Parameter list is created then use any one of the following syntax to call RUN_REPORT_OBJECT. e.g. RUN_REPORT_OBJECT (report_id REPORT_OBJECT paramlist_name VARCHAR2) or RUN_REPORT_OBJECT (report_id REPORT_OBJECT paramlist_id PARAMLIST); or RUN_REPORT_OBJECT (report_name REPORT_OBJECT paramlist_name VARCHAR2) or RUN_REPORT_OBJECT (report_name REPORT_OBJECT paramlist_id PARAMLIST);URL http://hostname/reports/rwservlet?destype cache&desformat html&server reportservername &report 'report_path/report.rdf'¶meterform no&userid username/password@databaseconnectstring ; In case of web deployment use WEB.SHOW_DOCUMENT( URL);
RE: What is the process to call a report from a form o...
By using RUN_PRODUCT procedure and by passing all the parameters on the same form from where we are calling the report without using any other parametric form