Home » Developer & Programmer » Reports & Discoverer » Sequential Numero per row in Report 10g
Sequential Numero per row in Report 10g [message #423283] Wed, 23 September 2009 03:50 Go to next message
randritsy
Messages: 20
Registered: June 2007
Location: Dago
Junior Member
I'd like to create a report, above grouped, like this

X
N° Name Sum
1 A 10000
2 B 1500
3 C 1500
4 D 2000
5 E 5000

Y
N° Name Sum
1 AA 10000
2 BB 1500
3 CC 1500
4 DD 2000
5 EE 5000


With "N°" is not a database column it's a sequential numero dynamically create with report, that increment per line but, reset by 0 if change group.
Can any one help me ? What code can i do?
Re: Sequential Numero per row in Report 10g [message #423308 is a reply to message #423283] Wed, 23 September 2009 05:15 Go to previous messageGo to next message
Littlefoot
Messages: 20894
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Use ROW_NUMBER analytical function in a query, such as
select row_number() over (partition by group_column order by name) no, name, sum
from ...

Or, create a summary column (COUNT is the function, source is the "name" column) and reset it on a group you are talking about.
Re: Sequential Numero per row in Report 10g [message #423456 is a reply to message #423308] Thu, 24 September 2009 06:56 Go to previous message
randritsy
Messages: 20
Registered: June 2007
Location: Dago
Junior Member
thanks a lot it's a good idea
Previous Topic: ORDER by DECODE
Next Topic: Issue in text formatting in oracle reports.
Goto Forum:
  


Current Time: Mon Dec 05 08:48:17 CST 2016

Total time taken to generate the page: 0.11778 seconds