OraFAQ Forum: Reports & Discoverer » Sequential Numero per row in Report 10g

Home » Developer & Programmer » Reports & Discoverer » Sequential Numero per row in Report 10g

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

Sequential Numero per row in Report 10g [message #423283]

Wed, 23 September 2009 03:50

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?

Report message to a moderator

Re: Sequential Numero per row in Report 10g [message #423308 is a reply to message #423283]

Wed, 23 September 2009 05:15

Littlefoot
Messages: 21808
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.

Report message to a moderator

Re: Sequential Numero per row in Report 10g [message #423456 is a reply to message #423308]

Thu, 24 September 2009 06:56

randritsy
Messages: 20
Registered: June 2007
Location: Dago

Junior Member

thanks a lot it's a good idea

Report message to a moderator

Previous Topic:	ORDER by DECODE
Next Topic:	Issue in text formatting in oracle reports.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 02:24:44 CDT 2024