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 |
What do you understand by lov?
What is the Maximum allowed length of Record group Column?
What are the built-in routines is available in forms 4.0 to create and manipulate a parameter list?
How to create lov dynamically in oracle forms which is data comes from database procedure of out parameter, data will will out parameter of procedure base
What do we mean by record group in oracle forms?
How to create LOV in Oracle forms?
How we can migrate the 6i report to 10g reports. What steps need to reuired?
List the editors availables in forms 4.0?
How can we generate report output in excel format?
How do you call other Oracle Products from Oracle Forms?
what is tripstop report?
can i write commit in Before report trigger