Friday, October 18, 2013

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 Behaviour: 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:

Post a Comment

Best Blogger TipsGet Flower Effect