Solved

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

Posted on 2010-09-09
5
2,127 Views
Last Modified: 2012-05-10
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
Comment
Question by:Fi-es
5 Comments
 
LVL 31

Expert Comment

by:RiteshShah
ID: 33634982
why don't you generate serial number from SQL Server itself and bind it to Crystal?????
0
 

Author Comment

by:Fi-es
ID: 33635699
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
 
LVL 19

Accepted Solution

by:
GJParker earned 500 total points
ID: 33635874
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
 
LVL 26

Expert Comment

by:Kurt Reinhardt
ID: 33637012
I would do what GJParker recommends, personally.

~Kurt
0
 
LVL 19

Expert Comment

by:GJParker
ID: 33654303
Did this work ?
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now