Home » Developer & Programmer » Forms » Call report
Call report [message #130744] Tue, 02 August 2005 04:09 Go to next message
abhijitmane2000
Messages: 20
Registered: June 2005
Location: Pune,Maharastra,India
Junior Member

How to call report from oracle forms,
I used run_report('report_name.rdf') on one button_pressed_trigger;

But it can't works.
Can u PLZ tell me in detail how to call it with syntax.

Thanx in advance.
Abhijit.

Can u please
Re: Call report [message #130771 is a reply to message #130744] Tue, 02 August 2005 07:12 Go to previous message
v_mitsuricha
Messages: 4
Registered: August 2005
Location: INDIA
Junior Member
Dear abhijit,
I am sending you print code which can be written on button and call it on When button pressed.
ADD_PARAMETER pass parameter from form to report, If you set it YES the parameter form will be visible before report.

Declare
RP paramlist;
BEGIN
RP:=create_parameter_list('tmpdata');
ADD_PARAMETER(RP,'PARAMFORM',TEXT_PARAMETER,'NO');
RUN_PRODUCT(REPORTS,'R_auth_usr.rep',SYNCHRONOUS,RUNTIME,FILESYSTEM,RP,NULL);
DESTROY_PARAMETER_LIST(RP);
END;

Richa
Previous Topic: D2k Material
Next Topic: WHEN LOV DOES NOT RETURN ANY RECORD
Goto Forum:
  


Current Time: Fri Sep 20 00:28:33 CDT 2024