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 are User Exits and what are different types of User Exits in Oracle Apps ?
How can a break order be created on a column in an existing group?
Is a Keystartup trigger fires as result of a operator pressing a key explicitly ?
difference between repeating frame and frame
can u call procedure or function is sq l query in reports
What is the usage of the confine mode in Layout Editor ?
System.effective_date system variable is read only True/False
Name the two files that are created when you generate the form give the filex extension ?
While connecting to Oracle Db i am getting the following error message- ORA-12154: TNS:could not resolve the connect identifier specified what are the steps to solve this problem?
Is it possible to disable the parameter from while running the report?
What is the difference between NAME_IN and COPY ?
How many Flexfields are there in AR and what are they ?