• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2374
  • Last Modified:

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
0
Fi-es
Asked:
Fi-es
1 Solution
 
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
 
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
 
Kurt ReinhardtSr. Business Intelligence Consultant/ArchitectCommented:
I would do what GJParker recommends, personally.

~Kurt
0
 
GJParkerCommented:
Did this work ?
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now