Oracle Reports (MOSC)

MOSC Banner

srw.run_report not working

edited Jul 19, 2009 11:19PM in Oracle Reports (MOSC) 1 commentAnswered
I am seeking help on invoking an oracle report from another oracle report. The parameters of each report are exactly the same as each other. The reports normally appear as a SCREEN report as users have to fill in the parameters. One report grants a permit, the other report issues a letter saying the user has been granted a permit. I am running oracle 6i reports by the way.

I put the srw.run_report command initially in the 'AFTERREPORT' trigger of reprot1. However, this doesn't fire when testing either using reports builder or reports runtime. I know this is true as I put a srw.message in the trigger to show this. So, I put the code into AFTERPARAMETERFORM instead. This does fire, but I am not sure if this is the correct place to put it since report 1 may not have completed yet.

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