forms and reports [message #132274] |
Thu, 11 August 2005 12:24 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
dmack
Messages: 42 Registered: March 2005 Location: TNT
|
Member |
|
|
Hi everyone
I would like to run a report from a form. I have created a button so that when pressed the parameter form for the specified report should come up. I have written the code below, however when button pressed i get the message . I am certain theis is the name of the report [COLOR=red]chgctrl[/COLOR.
Please indicate to me where I possibly went wrong.
DECLARE
repid REPORT_OBJECT;
v_rep VARCHAR2(100);
BEGIN
repid := find_report_object('chgctrl.rep');
v_rep := RUN_REPORT_OBJECT(repid);
END;
|
|
|
Re: forms and reports [message #132286 is a reply to message #132274] |
Thu, 11 August 2005 13:54 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
shahzaib198
Messages: 6 Registered: August 2005
|
Junior Member |
|
|
Well the correct method is
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;
|
|
|
|