Calling a Report from a Form

  

Calling a Report from a Form

Using RUN_PRODUCT Built-in we can call a Report from a Form.

It will take 7 Parameters as follows

1) Product name :: REPORT/GRAPHICS

2) Module name  :: Report name

3) Communication Mode :: Synchronous /Asynchronous

SYN :: we cannot work with the Form until and unless you closes the Report.

ASYN:: We can work with Form & Reprot (Navigate)

4) Exec :: Batch/Run time

Batch :: it will fetch all records at a time

Run time :: It will fetch only one Record at a time

5) File name :: database/Filesystem

6) Parameters :: Report Parameters

7) Display :: For Graphics (Mostly null)

Ex :: If we have :p_deptno parameter then we can call as Follows

RUN_PRODUCT (‘REPORT’,’C:\TEST1.rep’,SYN,BATCH,DATABASE,p_deptno,’ ‘);