add

About Me

My photo
Oracle Apps - Techno Functional 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
BEGIN
  srw.run_report('module=C:\Documents and Settings\Administrator\Desktop\POXDETIT.rdf destype=Screen');
END;

No comments: