Home » Developer & Programmer » Reports & Discoverer » Serial No. in reports
Serial No. in reports [message #88473] Tue, 24 September 2002 23:11 Go to next message
Rajeev Katyal
Messages: 55
Registered: April 2002
Member
how can we insert serial No. into reports( Oracle reports 2.5).
like suppose we are showing records from emp table then before each record it should display serial no:

====simple form of report=====

Ename sal
-------------------
john 5000
smith 7500
black 4500

=====the required form is=======

No. Ename sal
---------------------------
1 john 5000
2 smith 7500
3 black 4500

Pls help how to do the same.

Rajeev Katyal
Re: Serial No. in reports [message #88475 is a reply to message #88473] Wed, 25 September 2002 18:54 Go to previous message
ram kumar
Messages: 113
Registered: August 2002
Senior Member
hi
select rownum,ename,sal from emp:
regards
ram
Previous Topic: Splitting Reports
Next Topic: a) Page numbers b) positioning of printing
Goto Forum:
  


Current Time: Fri Mar 29 01:03:18 CDT 2024