| Re: urgent [message #90107] |
Thu, 28 October 2004 22:59  |
jhsharma
Messages: 58
Registered: June 2004
|
Member |
|
|
hi
i am newbie. i want to use run_product i have made it but i am not able to understand what querry and parameter etc to be declared in report for run_product from form to run the report. i
DECLARE
pl_id ParamList;
BEGIN
:pdate := :desp_date;
:pserial :=:desp_serial;
pl_id := Get_Parameter_List('tmpdata');
IF NOT Id_Null(pl_id) THEN
Destroy_Parameter_List( pl_id );
END IF;
Add_Parameter(pl_id,'REP_PRINT',DATA_PARAMETER,'PRINT_REC');
Run_Product(REPORTS, 'C:Documents and SettingsJHSHARMAMy Documentsexportdespnew.rdf', SYNCHRONOUS, RUNTIME,
FILESYSTEM,pl_id, NULL);
END;
what is wrong with above syntax
pl help me out
regards
|
|
|
|
| Re: urgent [message #90108 is a reply to message #90107] |
Fri, 29 October 2004 04:46  |
Himanshu
Messages: 457
Registered: December 2001
|
Senior Member |
|
|
Hi,
DECLARE
pl_id ParamList;
BEGIN
--:pdate := :desp_date;
--:pserial :=:desp_serial;
pl_id := Get_Parameter_List('tmpdata');
IF NOT Id_Null(pl_id) THEN
Destroy_Parameter_List( pl_id );
END IF;
Add_parameter(L_Rp_Nm, 'Pdate', Text_Parameter,:desp_date);
Add_parameter(L_Rp_Nm, 'pserial', Text_Parameter,:=:desp_serial);
Run_Product(REPORTS, 'C:Documents and SettingsJHSHARMAMy Documentsexportdespnew.rdf', SYNCHRONOUS, RUNTIME,
FILESYSTEM,pl_id, NULL);
END;
HTH
Regards
Himanshu
|
|
|
|
| Re: urgent [message #90112 is a reply to message #90108] |
Fri, 29 October 2004 21:17 |
jhsharma
Messages: 58
Registered: June 2004
|
Member |
|
|
hi Himanshu
what does L_RP_Nm stands for ?
Compilation error "P_RP_Nm must be declared"
if iremove it and replace it with pl_id
then the run time error
"can not add parameter to list Invalid list id" error message No FRM-47009
pl guide what to it.
regards
jai
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
