| Link between forms and reports [message #144011] |
Mon, 24 October 2005 11:12  |
Niranjan_1983
Messages: 12
Registered: June 2005
Location: Chennai
|
Junior Member |
|
|
1.I need to transfer a form parameter value into report parameter
2. If it is not possible when i call report from from i need to hide the parameter form in the report will you be kind enough to help me ot in solvin the above
|
|
|
|
|
|
|
|
| Re: Link between forms and reports [message #192895 is a reply to message #192879] |
Thu, 14 September 2006 02:32  |
sandeepk7
Messages: 137
Registered: September 2006
|
Senior Member |
|
|
Try this code
begin
pl_id:=get_parameter_list('tempdata');
if not id_null(pl_id) then
destroy_parameter_list(pl_id);
end if;
pl_id:=create_parameter_list('tempdata');
/* use below code to pass parameter from form to report. here parameter1 is name of parameter defined in Report and :text_item is item which contains the value which is to be passed */
add_parameter(pl_id,'parameter1',text_parameter,:text_item);
/* to hide parameter form at runtime */
add_parameter(pl_id,'PARAMFORM',text_parameter,'NO');
run_product(reports,'Report_name',synchronous,runtinme,filesystem,pl_id,");
end;
Sandy
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
