Oracle Reports

[shaka0995]

I am wondering if any one can tell me how can i get row number with each row in a report.
i.e there 1 against the first row 2 against the second row and so on.

[vbaskar]

Hi

Create one Summary column in the GROUP and reset it in the end of the report. The summary column will have the count of any one field u choose.

Example

GROUP
=====
EmpNo
Ename
Deptno
Dname
-> Reset criteria = End of the Report
Function = Count
Column = Empno

Vijays

[shaka0995]

I tried your solution but it dose not works it gives the count total at the end of the report but not with each row.
Thank you

[aph]

Are you looking some thing>>>>

SQL> select rownum, ename, sal from emp;

ROWNUM ENAME SAL
--------- ---------- ---------
1 SMITH 800
2 ALLEN 1600
3 WARD 1250
4 JONES 2975
5 MARTIN 1250
6 BLAKE 2850
7 CLARK 2450
8 SCOTT 3000
9 KING 5000
10 TURNER 1500
11 ADAMS 1100
12 JAMES 950
13 FORD 3000
14 MILLER 1300

14 rows selected.

[shaka0995]

Yes that what i am looking for but wiht rownum if i use order by clause it will change the results.