Answer / Rajat Madan

In Oracle Forms Reports, a complex report can be prepared by using various features such as Subreports, Crosstabs, and Grouping. To prepare a complex report, follow these steps: 1. Design the report structure using the Report Wizard or by manually creating it in the Form Editor. 2. Add necessary sections, subreports, and groupings as needed. 3. Set up the report properties such as column widths, page breaks, and header/footer information. 4. Define queries for data retrieval and bind them to the appropriate sections. 5. Run the report using the Form Builder or by executing it from a menu item.

What package procedure used for invoke sql plus from sql forms ?

1 Answers  

---

How to create LOV in Oracle forms?

2 Answers   Accenture, Polaris,

---

What are the built_ins used the display the LOV?

1 Answers  

---

What are the type of User Exits ?

1 Answers  

---

Explain the various types of oracle report?

1 Answers  

---

can i write commit in Before report trigger

4 Answers  

---

What is a Check Box?

1 Answers  

---

List the buil-in routine for controlling window during run-time?

1 Answers  

---

I am using oracle developer suit(form 10g), On used ole2 objects to initialize excel and worksheet and on "BEFORE REPORT" i am printing report heading in excel using OLE2 objects only. if i run report from developer suit report builder it give output in excel normally and what expected but when ever i put same report on server and run report from application it gives error : " Terminated with error : <br> REP-1401 'before report': FATAL pl/sql error occured. ORA-43356; message 43356 not found; Product=RDBMS; facility = ORA." Please reply it is urgent

0 Answers  

---

What is the between Function and Procedure?

3 Answers   HCL,

---

How do u print the data horizantally by using XML report? EX:Suppose there is one table names as SAMPLE in that we have only two columns say empno,ename.I want the output like this,At run time user may enter 3 colums(i.e to data print horizantally). empno ename empno ename empno ename 100 aaa 101 bbb 102 ccc 103 ddd 104 eee 105 fff

1 Answers   Intelligroup, TTPL,

---

What is the built_in routine used to count the no of rows in a group?

1 Answers  

---