Home » Developer & Programmer » Reports & Discoverer » Passing Parameter from form to report
Passing Parameter from form to report [message #88315] Thu, 27 June 2002 09:11 Go to next message
Godwin
Messages: 37
Registered: January 2002
Member
I have this script on when-button-press trigger in forms 6.o that call the report to send the parameter to the report but when i run the report i always have to error: 'REP-0302:Parameter 'p_1' not found in report'
here is the script:

declare
plid paramlist;
the_param varchar2(15):='tmpdata';
BEGIN
plid:=GET_PARAMETER_LIST(the_param);


IF NOT id_null(plid) THEN
destroy_parameter_list(plid);

END IF;
plid := create_parameter_list(the_param);
add_parameter(plid,'P_1',TEXT_PARAMETER,:block3.paanum);
RUN_PRODUCT(REPORTS,'C:personnel_itscontractappt.rep',SYNCHRONOUS,
RUNTIME,FILESYSTEM,plid,null);


END;

Help.
Re: Passing Parameter from form to report [message #88316 is a reply to message #88315] Thu, 27 June 2002 10:45 Go to previous message
gary herman
Messages: 5
Registered: June 2002
Junior Member
Did you code a parameter P1 in the Report block to receive the parameter?
Previous Topic: Report Scheduling
Next Topic: can't print report in landscape orientation
Goto Forum:
  


Current Time: Thu Mar 28 23:46:29 CDT 2024