Home » Developer & Programmer » Reports & Discoverer » Row Number
Row Number [message #88609] Tue, 10 December 2002 20:08 Go to next message
Shofi
Messages: 3
Registered: October 2002
Junior Member
Hi Friends,
How can I give serial number or row number in a report where I am using group by query. Could any body help me?

Thanks.
shofi
Re: Row Number [message #88610 is a reply to message #88609] Wed, 11 December 2002 06:41 Go to previous messageGo to next message
ram kumar
Messages: 113
Registered: August 2002
Senior Member
hi,
just write a function which increments by 1
hope you understood what I mean
ram
Re: Row Number [message #88624 is a reply to message #88609] Wed, 18 December 2002 17:53 Go to previous messageGo to next message
Balan Anil Kumar
Messages: 5
Registered: November 2002
Junior Member
Hi Ram,

I am getting 1 in all rows. kindly send the script if u can?

Thanks
Anil.
Re: Row Number [message #88628 is a reply to message #88624] Wed, 18 December 2002 23:06 Go to previous messageGo to next message
Ravi
Messages: 251
Registered: June 1998
Senior Member
Hi Anil,
I belive you need to display Serial Numbers in Report, for that can't you create a Summary Column.
In Data model editor inside your query you create one Summary Column..goto the property of summary column use Function-> COUNT on which feild you want and which group automatically in the output you can see the Serial Numbers.

Regards,
Ravi
Re: Row Number [message #88642 is a reply to message #88609] Tue, 31 December 2002 02:23 Go to previous message
Manoj
Messages: 101
Registered: August 2000
Senior Member
Hi Ram,

Looking for Oracle Developers for Gurgaon, India.

Details of Requirement are:-
Person should have min. 3yrs. of experience on Developer 2000 (forms 6i and Reports), Oracle 8i, SQL, PL/SQL.

Pls. let me know your avail. for the same and if interested, pls. send me your updated resume immediately by return mail. In case you are not interested, I would appreciate if you can refer me some of your Friends/Colleagues/Acquaintances.

In anticipation of an immediate reply from your end.

Manoj
Previous Topic: Oracle Reports Triggers
Next Topic: Trunc Date in report
Goto Forum:
  


Current Time: Mon May 16 20:48:30 CDT 2022