How to call report through form builder and pass parameter.

You can call report through form builder also you can pass parameters through form to report.

Just paste this code behind the button on form builder then call a report

  • On report parameter name: “indent_id”
  • On form parameter name :    “indent_trans_id”
  • Report Name and location: D:\INDENTS.REP

——————————————–

declare
temp_id paramlist;
begin
temp_id := CREATE_PARAMETER_LIST(‘V_A’);
ADD_PARAMETER(temp_id,’indent_id’,text_parameter,:indent_trans_id);
ADD_PARAMETER(temp_id,’paramform’,text_parameter,’NO’);
add_parameter(temp_id,’MAXIMIZE’,TEXT_PARAMETER,’YES’);
run_product(reports,’D:\INDENTS.REP’,synchronous,runtime,filesystem,temp_id);
destroy_parameter_list(temp_id);
end;

————————————————————————–