Re: (no subject)

From: RAM MAREDDY <rmareddy_at_calibersys.com>
Date: 1997/01/20
Message-ID: <01bc0709$06575ca0$1639e028_at_cti-i71-rm01>#1/1


Hari:

You can use RUN_PRODUCT to invoke Reports from Forms. To pass on the individual parameters that are there on the Report, use ADD_PARAMETER.

Following is an example:

PROCEDURE Run_Report IS

 param_list_id ParamList;
 param_list_name VARCHAR2(20) := 'Report_pl';

BEGIN  

 /************************

  Make up Parameter Holders
  *************************/

  • Make sure that parameter list does not exist. param_list_id := Get_Parameter_List(param_list_name); IF NOT ID_NULL (param_list_id) THEN MESSAGE('Parameter_list ' || param_list_name || ' already exists.'); RAISE FORM_TRIGGER_FAILURE; END IF;
  • Create the parameter list. param_list_id := CREATE_PARAMETER_LIST(param_list_name); IF ID_NULL(param_list_id) THEN MESSAGE('Parameter_list ' || param_list_name || ' can not be created.'); RAISE FORM_TRIGGER_FAILURE; END IF;
 ADD_PARAMETER(param_list_id, 'HEADING', TEXT_PARAMETER, 'Test Report');  RUN_PRODUCT(REPORTS, 'myrep.rdf', SYNCHRONOUS, RUNTIME, FILESYSTEM, param_list_id, NULL);
  • Destroy the parameter list. DESTROY_PARAMETER_LIST(param_list_id);

END; Good Luck,
Ram Mareddy
rmareddy_at_calibersys.com
Akron, OH 44313

s.r.rangaraju <ranga_at_ihug.co.nz> wrote in article <5bsljh$qgq_at_newsource.ihug.co.nz>...
> how to invoke reports2.5 from forms4.5?????????
>
> hari
>
>
  Received on Mon Jan 20 1997 - 00:00:00 CET

Original text of this message