Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

run_report_object with report_other_param

shahid_patelMay 22 2023 — edited Aug 25 2023

the run_report_object example has below line (for other parameters)

SET_REPORT_OBJECT_PROPERTY(v_report_id,REPORT_OTHER, 'p_deptno='||:dept.deptno||'paramform=no');

confused about p_deptno, should I need to define it first in report parameter/parameter form first?

actually, I need to pass a parameter for each report without parameter defined in each report. It is a global variable available in all forms but same needs to pass all report through a FORM (which is standard/generic to run any report)

thanks

This post has been answered by Michael Ferrante-Oracle on May 23 2023

Jump to Answer

Added on May 22 2023

#forms, #moved-from-devops, #oracleforms, #reports

3 comments

552 views