Answer Posted / 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,' ');

Name the different triggers supported by oracle reports and their firing order.

1061

---

why the Ctl file u put only in bin folder why not in other folder

2026

---

What is responsibility and how u attach How to create user and how u attach with responsibility.

2015

---

Can you convert a bit-mapped report to ASCII (character-mode) Report ? How ?

2267

---

What is the difference between BPA AND Contract What are documents and test cases u followed

2365

---

Can we invoke one form from another in a multi-forms application?

1111

---

What is a canvas in oracle forms?

1049

---

What is an oracle report?

1026

---

List out the oracle forms configuration files?

1053

---

hiding item in report how like that properly,thats manually but at runtime i want to do

3213

---

suppose u have been seven tables based on that u have to create a report u don't have access to db. then how do u find the relation between tables

2009

---

What do we mean by record group in oracle forms?

1049

---

what are bind variables?

1065

---

List the different types of columns in oracle reports.

979

---

What is the difference between bind and lexical parameter?

1053

---