Answer Posted / debmalya gupta

select sum(column_name) into l_return from table_name
where column_name >=0

paste this in a formula column and make it the source of
sum amount..

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

2954

---

Explain master-detail relationship with some examples.

953

---

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

3158

---

Have you come across the error ?Failed while printing ?. Why it is happened and How to solve that?

1938

---

what are bind variables?

1021

---

What do you understand by lov?

990

---

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

1938

---

what is the difference between call_form, new_form and open_form?

1225

---

what is a package n what r the packages availbla in report

2039

---

how do u place it in required folder

1873

---

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

4516

---

How can we generate report output in excel format?

947

---

What is a user exit program in oracle reports?

975

---

Can any one send me oracle form and reports tutorials from which i may get help.contact me on my mail cse_kashif@hotmail.com.

2179

---

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

1070

---