how do u call a report from form
Answers were Sorted based on User's Feedback
Answer / lokanatha reddy
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 i have :p_deptno parameter then we can call as
Follows
RUN_PRODUCT
('REPORT','C:\TEST1.rep',SYN,BATCH,DATABASE,p_deptno,' ');
| Is This Answer Correct ? | 16 Yes | 2 No |
EXIT_FORM is a restricted package procedure ?
What are built-ins used for Processing rows?
What is strip sources generate options?
What is an User_exit?
how do u place it in required folder
What is the usage of frame ?
How to create LOV in Oracle forms?
What built-in is used for showing the alert during run-time?
where do u put the report file
Where do u define the select statement of the parameter? is it followed by the & variable ?
can my report have different layouts
Can a property clause itself be based on a property clause?