How to call report from Oracle form

Call report in the menu Program (If you do not specify a parameter, you can use the following program segment for passing the parameter) run_product (reports, 'Report program name. rep ', synchronous, runtime, filesystem, '', null); call the Report Program (optional parameters) in Form declare Pl_id paramlist; Begin Pl_id: = get_parameter_list (' Parameter List name '); If not id_null (pl_id) then Destroy_parameter_list (pl_id ); End if; Pl_id: = create_parameter_list (' Parameter List name '); Add_parameter (pl_id, 'Report Parameter Name: 1', data_parameter, ': Form Item Name: 1 '); Add_parameter (pl_id, 'Report Parameter Name: 2', text_parameter, ': Form Item Name: 2 '); ... ... Run_product (reports ,' Report program name. Rep ', synchronous, runtime, filesystem, pl_id, Null ); End; when using parameters as helper variables in the report, add a colon (:) before the variable. For example, if there is a parameter p_deptno, the incoming value is 10, select * Form EMP where deptno =: p_deptno will return the record with deptno 10 in the EMP table. When you use a parameter as a vocabulary parameter in a report, add the "and" symbol (&) before the start. For example, if there is a parameter p_where, The sent value is where deptno = 10, select * from EMP & p_where will also return the record with deptno 10 in the table EMP. Remove the Report Server when calling the report:
Add_parameter (pl_id, 'oracle _ shutdown ', text_parameter, 'yes '); When a report is called, the report result is directly output to the printer:
Add_parameter (pl_id, 'psrameter _ Form', text_parameter, 'no '); When a report is called, the parameter window is not displayed:
Add_parameter (pl_id, 'paramform ', text_parameter, 'no '); When a report is called, it is displayed in full screen mode:
Add_parameter (pl_id, 'maximize', text_parameter, 'yes ');