About Me

My photo
Oracle Apps- Technical consultant

Wednesday, July 23

How to run one report from another report

Running nested reports:

For running one report from another report the user has to use SRW.RUN_REPORT
Go to layout editor
 create a button and label it as ‘Click this button’
Open the property palette of the button and set the Button Behavior:
Type=pl/sql: Pl/sql
Trigger= provide the code
procedure U_ButtonButtonAction is
  srw.run_report('module=C:\Documents and Settings\Administrator\Desktop\POXDETIT.rdf destype=Screen');

No comments: