Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2444
  • 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
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.

Join & Write a Comment

Featured Post

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

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