I have defined the following code for executing the report from the form by clicking on button. we want to print the report whatever the Purchase_order_no, we have entered in the Form text item :purchase_order_master.Pur_order_no.
Report is showing the data but not the specific Purchase_order_no which we have entered in FOrm Text Item. it is showing the error also define below.
somebody can help me.
DECLARE
plid ParamList;
BEGIN
plid := Get_Parameter_List('tmpdata');
IF NOT Id_Null(plid) THEN
Destroy_Parameter_List( plid );
END IF;
plid := Create_Parameter_List('tmpdata');
Add_Parameter(plid,'PURORDERNO',DATA_PARAMETER,:purchase_order_master.Pur_order_no);
Add_Parameter(plid, 'PARAMFORM', TEXT_PARAMETER, 'NO');
Run_Product(REPORTS, 'D:\NOVEMBER_2011\New_Sunrays_System\N_Purchase_Order.rdf', SYNCHRONOUS, RUNTIME,
FILESYSTEM, plid, NULL);
<Error>
frm-47012 Cannot add parameter PURORDERNO to the paramenter list tmpdata : group 3 does not exist
<Error>
thanx
shafiq
[Updated on: Wed, 02 November 2011 12:50] by Moderator
Report message to a moderator
] 
Blog
Search
Help
Members
Register
Login
Home
