Home » Developer & Programmer » Reports & Discoverer » adding sequence to report (oracle 10g R2, windows7)
adding sequence to report [message #558718] Tue, 26 June 2012 02:00 Go to next message
7anona
Messages: 72
Registered: February 2012
Member
hello to all,,
I'm having a report and I want to add sequence.
my report is group by type. I want the sequence to restart for every new group

lets say a report having name of studens of different classes and grouped by class
the result should look like this:

class A
1.student1
2. student2

classB
1.student3
2.student4

what I did is created a summary column with count function with source student but the sequence did not restart when group is changed

please advise as soon as possible
Re: adding sequence to report [message #558722 is a reply to message #558718] Tue, 26 June 2012 02:21 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Did you correctly set its "Reset at" property?
Re: adding sequence to report [message #558731 is a reply to message #558722] Tue, 26 June 2012 02:44 Go to previous message
7anona
Messages: 72
Registered: February 2012
Member
no, I had no idea about its use,Thanks you it works now.
Previous Topic: Discoverer - 'Running Total' calculation
Next Topic: Rename of Reports server 11g r2
Goto Forum:
  


Current Time: Sat Nov 30 05:10:04 CST 2024