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

I have a frame that contains headings. This frame is enclosed in side a repeating frame. However the headings are not displayed on all pages it is displayed only on the last page. Please let me know why is this happening. print object on = All pages base printing on = enclosing object

2274

---

What do we mean by record group in oracle forms?

610

---

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

1594

---

what is tripstop report?

1354

---

Explain the different levels at which oracle form services interact.

601

---

---

List the different types of columns in oracle reports.

570

---

i am having a report Jan to Dec are the columns if the present month is Mar only Mar to Dec columns should appear in report output

1565

---

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

637

---

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

2551

---

In oracle forms report, what is the maximum length of record group column? What are the different types of record groups?

811

---

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

4018

---

what are the oracle forms services components include?

555

---

in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement

1292

---

can you convert or reverse engineer a fmx back to a fmb file?

706

---

what is oracle forms?

600

---