Answer Posted / sohail

Caution,Stop and Note.

i want to print the employee details on department wise with group above report with the fields DEPTNO------group above ENAME ------ SAL-------- COMM------ I WANT OUTPUT LIKE THIS ---------------------------------------------------------- 1)FIRST DEPTNO=10 EMPLOYEES DISPLAYED IN FIRST PAGE AND DEPTNO=20 EMPLOYEES DISPLAYED IN 2ND PAGE WHAT I HAVE TO DO OUTPUT ------- --FIRST_PAGE ----------- DEPTNO:10 ENAME SAL COMM KING 5000 A 2000 2222 ---- =- -- SECONDPAGE DEPTNO:20 ENAME SAL COMM MILLER 220 22 D 45 23 -- - - LIKE THE ABOVE PROCDURE REPORTS HOW MANY DEPARTMENTS ARE EXISITING IN EMP TABLE

3046

---

List the different types of columns in oracle reports.

1046

---

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

1137

---

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

2091

---

In workflow how can we send a notification to the Supplier giving the Corresponding report Details.

1958

---

if some data is not transfered where it will get stored

1991

---

How to create Drill down report?

2185

---

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

1205

---

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

1750

---

what are bind variables?

1142

---

if i want to change the functionality of a item in report during runtime how like what do u write in when_button_pressed

1944

---

What is a matrix report and how many minimum groups are required to prepare the same?

1200

---

difference between global n context sensitive segments?

2728

---

Explain the various types of oracle report?

1131

---

What is an oracle report? List its various types.

1019

---