| How to call Oracle 9i report from Oracle form 9i [message #83397] |
Fri, 03 October 2003 04:59  |
Rahul
Messages: 94
Registered: December 1998
|
Member |
|
|
Hi,
Anybody tell me how to call a report which i create using 9i from form 9i.
i create a report using oracle report 9i and its working fine.i the form 9i when in the when_button_pressed i want to call the report.
any please explain the steps? is there anything to added in the setup???
Thanks.
|
|
|
|
|
|
|
|
| Re: How to call Oracle 9i report from Oracle form 9i [message #84042 is a reply to message #83397] |
Wed, 21 January 2004 02:50  |
Teani
Messages: 1
Registered: January 2004
|
Junior Member |
|
|
Here is an example using run_product to start the report server and generate a report from forms. Check the documentation for this command to get more information about configuration possibilities.
declare
l_file varchar2 (80);
l_pl_id paramList;
l_pl_name varchar2(10) := 'repParm';
begin
l_file := 'Path and name of report to run';
l_pl_id := get_parameter_list(l_pl_name);
if not id_null(l_pl_id) then
destroy_parameter_list(l_pl_id);
end if;
l_pl_id := create_parameter_list(l_pl_name);
add_parameter(l_pl_id,'p_assignment_id',TEXT_PARAMETER,'custom parameter for report');
add_parameter(l_pl_id,'desname',TEXT_PARAMETER,
'path and filename of the output report');
add_parameter(l_pl_id,'desformat',TEXT_PARAMETER,'pdf');
add_parameter(l_pl_id,'destype',TEXT_PARAMETER,'file');
-- Call the reports server
run_product(REPORTS,l_file,SYNCHRONOUS,BATCH,FILESYSTEM,l_pl_id,null);
end;
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
