OraFAQ Forum: Reports & Discoverer » Sequence No reinitialization

Home » Developer & Programmer » Reports & Discoverer » Sequence No reinitialization

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

Sequence No reinitialization [message #406809]

Sat, 06 June 2009 00:47

jkanani
Messages: 4
Registered: June 2009
Location: Ahmedabad

Junior Member

Hi,

I am using Ora report 10g. I want to reinitialize sequence number when group field change. to be more specific say there are container number and each container may have number of bundles. How can the sequence number be reinitialize when container no get change. e.g.

CONT No : CONT1
===============
Seq. No. BUNDLE No.
====== =========
1 abc
2. bcd
3. cdf

CONT No : CONT2
===============
Seq. No. BUNDLE No.
====== =========
1 xyz
2. pqr
3. mno

Report message to a moderator

Re: Sequence No reinitialization [message #406828 is a reply to message #406809]

Sat, 06 June 2009 03:16

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Create a summary column; function is "Count", its source should be "Bundle No" and should be reset at "CONT No" group.

Another option is to use analytical function, such as

SELECT cont_no, bundle_no,
  ROW_NUMBER() OVER (PARTITION BY cont_no ORDER BY cont_no, bundle_no) rn
FROM your_table
WHERE ...

If you choose to use this approach, you don't need to create a summary column (of course).

Report message to a moderator

Re: Sequence No reinitialization [message #406829 is a reply to message #406828]

Sat, 06 June 2009 03:24

jkanani
Messages: 4
Registered: June 2009
Location: Ahmedabad

Junior Member

Created summary column & It's works fine.

Thanks.

Report message to a moderator

Previous Topic:	Report flooding smtp ?
Next Topic:	Conditional Printing

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Nov 27 04:00:04 CST 2024