How to reset Crystal Report's Record Number on change of group?

Hi All,

I need a report of items grouped by item category like below. I use Crystal Report 7.

Category A
  1. Item1
  2. Item2
  3. Item 3

Category B
  1. Item4
  2. Item5


I get below result:
Category A
  1. Item1
  2. Item2
  3. Item 3

Category B
  4. Item4
  5. Item5

The problem is...

Item serial number is not reset for each group. You can see Category B starts with item serial number 4.  How to reset Record Number on change of group?

Thank You
Regin T
Fi-esAsked:
Who is Participating?
 
GJParkerCommented:
You could use a running total have the summary as a count of item, evaluate fro each record and reset on change of category group

HTH
0
 
RiteshShahCommented:
why don't you generate serial number from SQL Server itself and bind it to Crystal?????
0
 
Fi-esAuthor Commented:
I am supposed not to change the stored procedure.  But I have to prepare the report in the format I explained.

I may use formula in crystal report.
0
 
Kurt ReinhardtSr. Business Intelligence Consultant/ArchitectCommented:
I would do what GJParker recommends, personally.

~Kurt
0
 
GJParkerCommented:
Did this work ?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.