Re: Passing parameter from form 4.5 to report 2.5

kirill_at_cs.ualberta.ca (Kirill Richine) wrote:
>Hi!
>
>I was wondering how I can pass a parameter from form 4.5 to report
>2.5.
>I am using RUN_PRODUCT.
>
>I create a menu item called Report and associate the PL/SQL code with
>this item, which contains the call to
>param_list_id := Create_Parameter_List ('tmpdata');
>Add_Parameter (param_list_id,????, DATA_PARAMETER, ?????);
>RUN_PRODUCT (Reports, 'filename', SYNCHRONOUS, RUNTIME, FILESYSTEM,
>param_list_id, NULL);
>
>In my report, there is a parameter P_PARAM1.
>In my form there is a field whose current value I want to pass to this
>parameter list :bl1.field1.

Add_Parameter (param_list_id,????, DATA_PARAMETER, ?????);

• ----- 'P_PARAM1' :b11.field1 Don't forget the '
  >
  >The example in the Reference presents some weird case when the
  >parameter is the entire query (? what does it actually mean).
  When the report depends on a query from a form
  >
  >Is it possible to pass just one parameter that would substiture for
  >the parameter in the report?
  >
  >Thank you.
  >k&
  

-- 
Eric L'HUILLIER

---------------------------------------------------------------------------
! Rien n'est plus sur que l'informatique a part peut-etre l'astrologie.   !
! Nothing is more reliable than computer science except astrology.        !
---------------------------------------------------------------------------
! Ce message n'exprime qu'un point de vue purement personnel.             !
! This message expresses my own opinion and doesn't involve my company.   !
---------------------------------------------------------------------------

eric.l.huillier_at_ifremer.fr

IFREMER Brest (FRANCE)

Tel : +(33) 98.22.47.40