Using Button Action Trigger to Run Another Report with Parameter

[Mohanram]

Hi,

I need to call a report ( say, Report2 which has a parameter form attached to it ) from a button action in Report 1.
When I formulate SRW.RUN_REPORT, Oracle manual specifies that we should add paramform=yes

When I add that and call the report it gets executed with null values, with out showing the Parameter form of Report2 for input.

How do I make the button action open the called Report's parameter form ?

 

[Guest_imported]

Hi,
You can use

SRW.RUN_REPORT ('report=report_name p_parameter_name='||aram_value);

where aram_value can be a field in Report1 if you wish to dynamically populate the parameter's value

Hope this helps
Viji