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.
Printable View
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.
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
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
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.
Yes that what i am looking for but wiht rownum if i use order by clause it will change the results.