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

How to create Drill down report?

1701

---

What is a canvas in oracle forms?

600

---

Is it possible to have multiple layouts in a report?

580

---

how to use buttons,check boxes in paper layout,paper design and paper parameter form in oracle report developer 10g

1536

---

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

645

---

---

all steps of bitmap report?

1912

---

What is a user exit program in oracle reports?

580

---

What is an implicit anchor and how is it a different form explicit anchor in a report builder?

633

---

I need a query to list out "Subinventory Transfer" record from Oct 2016 to Oct 2017 for few users

847

---

how do u compile a form i.e .fmb file in Unix or in dos

4030

---

what are the new features introduced in oracle form services in 11g release 2?

588

---

What are the various configuration files that are used by oracle forms?

577

---

Explain the different levels at which oracle form services interact.

611

---

from where do u receive the information to develop report

1537

---

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

595

---