Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: A report called from a form
Hi,
if you use run_product, you should send the parameter list :
PROCEDURE Run_Emp_Report IS
pl_id ParamList;
BEGIN
pl_id := Get_Parameter_List('donnéestemp');
IF NOT Id_Null(pl_id) THEN
Destroy_Parameter_List( pl_id );
END IF;
pl_id := Create_Parameter_List('donnéestemp');
Add_Parameter(pl_id,'EMP_QUERY',DATA_PARAMETER,'EMP_RECS');
Run_Product(REPORTS, 'étatemp', SYNCHRONOUS, RUNTIME,
FILEYSTEM, pl_id, NULL);
END;
See online help for details.
Yann
Gato a écrit dans le message <9ui3r6$l4j$1_at_talia.mad.ttd.net>...
>When I call a report from a form, the parameter window appear, prompting
the
>values.
>How can I set de values for the variables?
>
>Thanks.
>
>--------------------------------------->
>
>Al llamar a un informe desde un formulario, aparece la ventana de
parámetros
>para que el usuario le introduzca los valores.
>¿Cómo puedo darle valores a esas variables, evitando que aparezca la
ventana
>de parámetros?
>
>Gracias.
>
>
Received on Wed Dec 05 2001 - 02:22:05 CST