Call report [message #130744] |
Tue, 02 August 2005 04:09 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 Go to previous message](/forum/theme/orafaq/images/up.png) |
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
|
|
|