Oracle Reports (MOSC)

MOSC Banner

srw.run_report and button trigger migration code from 6i reports to 10g report

edited Jun 21, 2018 12:52PM in Oracle Reports (MOSC) 6 comments
Hello,
Allow me to illustrate the question with example:

Having three  6i C/S reports : ZSPI_992 and ZSPI_993 and ZSPO_992.

ZSPI_992 and ZSPI_993 are two input controling reports before submitting the PL/SQL job - packade procedure ( sequence of transactions ).
ZSPI_992 has two buttons.
The button for drill down controlling reports ZSPI_993 is on the level of the report line in ZSPI_992 where field values are input parameters
for ZSPI_993 report.
 
The trigger for this button is like this:
Begin

p_Call := 'module=ZSPR_993.rep paramform=no' ||  'pf_account=' || :AccountDeb ||' pf_date993=' || to_char( :pf_date992, 'dd/mm/yyyy' );

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center