![]() Thus the next step is to check if the report *The report output is not delivered automatically to the client, which is okayīecause the Web is a request model. Vc_report_job_id:=RUN_REPORT_OBJECT(report_id) * finally, run the report and retrieve the Reports job_id as a handle to the SET_REPORT_OBJECT_PROPERTY(v_report_id,REPORT_OTHER, 'p_deptno='||:ptno||'paramform=no') SET_REPORT_OBJECT_PROPERTY(v_report_id,REPORT_SERVER, '') * replace with the name of the Reports Services as defined SET_REPORT_OBJECT_PROPERTY(v_report_id,REPORT_DESFORMAT, '') The Reports parameter form is suppressed by setting paramform to "no". * Define the Report output format and the name of the Reports Server as well asĪ user-defined parameter, passing the department number from Forms to the Report. SET_REPORT_OBJECT_PROPERTY(v_report_id,REPORT_DESTYPE,CACHE) SET_REPORT_OBJECT_PROPERTY(v_report_id,REPORT_COMM_MODE, SYNCHRONOUS) V_report_id:= FIND_REPORT_OBJECT('report_node1') * Get a handle to the Report Object itself. Vc_rep_status VARCHAR2(100) /* status of the Report job */ Vc_report_job_id VARCHAR2(100) /* unique id for each Report request */ ![]() The Reports parameter form is suppressed */ User-defined Reports parameter "p_deptno" is passed by Forms using the value in Report_object node defined in Forms Developer is assumed to be "report_node1". * The following example runs a report using the RUN_REPORT_OBJECT Built-in. To run a stack of reports asynchronously, the best option is reports server and using RUN_REPORT_OBJECT not RUN_PRODUCT, eg The "Preview" only really makes sense when you want to "pause" and view the report output before doing anything with it. To run a series of reports in the background, the aim is to have them run concurrently on the report server and product their output.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |