Home » Developer & Programmer » Reports & Discoverer » how to generate serial number on report at run time
how to generate serial number on report at run time [message #88243] Mon, 27 May 2002 07:19 Go to next message
rizwan
Messages: 8
Registered: November 2001
Junior Member
Dear Sir/Madam I have a problem related to oracle report. Suppose i have one table which contain two column, name and age and in this column 10 record is there . when i run this report definitly it will display 10 records but i need that it should 10 records along with serial number like 1 2 3 4 5------10 vertically.and this serial number is not data base column.So please help be and send the replly on my email as soon as possible.

Thanks
rizwan
Re: how to generate serial number on report at run time [message #88251 is a reply to message #88243] Tue, 28 May 2002 21:00 Go to previous messageGo to next message
rama krishna
Messages: 97
Registered: December 2001
Member
hii
create a summary column in the same group as of ur columns.. summary function is count and count on name...
this will print the serial numbers....

cheers
ram
Re: how to generate serial number on report at run time [message #88519 is a reply to message #88243] Sat, 26 October 2002 07:30 Go to previous messageGo to next message
Silver Joe
Messages: 1
Registered: October 2002
Junior Member
please
Re: how to generate serial number on report at run time [message #88522 is a reply to message #88243] Sun, 27 October 2002 23:09 Go to previous messageGo to next message
Ravi
Messages: 251
Registered: June 1998
Senior Member
Hi Silver,
You can Create one Summary Column for Serial number.
In the property of Summary Column
Summary :-

Function - Count
Source - Database column name
Reset at- Group,report Or page.

select Count Function instead of Sum. and on which database column you want to count so that it can generate serial no. and reset on any group or report level that also you have to mention.

i think you are looking for this..........

Regards,
Ravi

Ravi_selvan@satyam.com
Re: how to generate serial number on report at run time [message #88699 is a reply to message #88243] Tue, 04 February 2003 15:08 Go to previous message
nader
Messages: 1
Registered: February 2003
Junior Member
mp3 recorder
Previous Topic: Re: call report 6i from form 5.0.6
Next Topic: Converting Character mode Report to Bitmap report
Goto Forum:
  


Current Time: Sun Dec 22 22:18:10 CST 2024