-
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
Vijay.s
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|