Re: Communication: Forms => Reports

You have to create a parameter-liste within forms and then add your default where to that parameter, e.g. list_id := create_parameter_list ( 'mylist' ) ; add_parameter ( mylist, 'AA_LIKE', TEXTPARAMETER, :aa.like. Then call reports.
In Reports you must define a user-parameter "AA_LIKE". This parameter will receive your default-where. In the reports data-model you must use that parameter in the select statement like this: select ...
from ...
where &AA_LIKE.
"&AA_LIKE" is replaced by your default-where string. regards hans-dieter

Moshe schrieb:
>
> Hi Everyone
>
> I have form-browser of the table AA where user can input "default_where"
> parametr (:aa.like) and I have a button "Print it". How can I use that
> parameter (:aa.like) as a parameter of my report. Report should has the same
> records as the browser on the form. Of course I can ask user once again
> about that parameter, but I don't like it.
>
> Regards Moshe
Received on Fri Apr 13 2001 - 17:02:16 CEST