DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Oracle Reports

  1. #1
    Join Date
    Apr 2001
    Posts
    9

    Angry

    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.

  2. #2
    Join Date
    Jan 2001
    Posts
    153
    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

  3. #3
    Join Date
    Apr 2001
    Posts
    9
    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

  4. #4
    Join Date
    Jul 2001
    Posts
    334
    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.

  5. #5
    Join Date
    Apr 2001
    Posts
    9
    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
  •  


Click Here to Expand Forum to Full Width