OraFAQ Forum: Reports & Discoverer » Serial No. in reports

Home » Developer & Programmer » Reports & Discoverer » Serial No. in reports

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Serial No. in reports [message #88473]

Tue, 24 September 2002 23:11

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

Report message to a moderator

Re: Serial No. in reports [message #88475 is a reply to message #88473]

Wed, 25 September 2002 18:54

ram kumar
Messages: 113
Registered: August 2002

Senior Member

hi
select rownum,ename,sal from emp:
regards
ram

Report message to a moderator

Previous Topic:	Splitting Reports
Next Topic:	a) Page numbers b) positioning of printing

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 30 12:57:52 CST 2025