|
-
There are two ways to pass parameter.
1. You can create parameter form in report itself. Here you have to allow
users to enter parameter value.
2. You can create FORM. Run the report from FORM by passing the parameter to report
e.g.
A. Create one button.
B. Write following code in when-button-press trigger
declare
pl_id paramlist;
pl_name varchar(10) := 'rpt_param';
begin
pl_id := get_parameter_list(pl_name);
if not id_null(pl_id) then
destroy_parameter_list(pl_id);
end if;
pl_id := create_parameter_list(pl_name);
add_parameter(pl_id, 'P_REP_TITLE', text_parameter, 'Report Name');
Run_Product(REPORTS,'ABC', SYNCHRONOUS, RUNTIME,FILESYSTEM, pl_id, NULL);
end;
Here P_REP_TITLE is same parameter name must be exist in report.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|