Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: aproblem with The special field: record number Post Reply Post New Topic
Author Message
mohamed_salafi8
Newbie
Newbie


Joined: 05 Feb 2008
Location: Saudi Arabia
Online Status: Offline
Posts: 17
Quote mohamed_salafi8 Replybullet Topic: aproblem with The special field: record number
    Posted: 11 Jun 2008 at 11:20pm

I have a CR 10, where there is a list of class names, group by type. I also include a field of record number (using special field: record number). However, I want the record number start at 1 for each type group for example:

Group: Math
1. Algebra
2. Statistic
3. Calculus

Group: Chemistry
1. Organic
2. Analytical
3. Inorganic

and so on.

 

The special field: record number, does not want to do that, it continues on the number through all the groups. Can anyone help me, please?

IP IP Logged
rahulwalawalkar
Senior Member
Senior Member
Avatar

Joined: 08 Jun 2007
Location: United Kingdom
Online Status: Offline
Posts: 731
Quote rahulwalawalkar Replybullet Posted: 12 Jun 2008 at 4:26am

Hi

Create running totals 

Go to Filed Explorer  Menu View --->Field Explorer
 
Then Select running totals node create new running total field
 
Then use the settings below
 
Select Filed to summarize ----any numeric field such as Id or primary key id field
 
Select Type of summary :-Count

Evaluate - Select for each record

Reset - On Change of Group i.e Math ,Chemistry
 
Place the running total field against Alegbra,Statistic .....
 
That should work
 
cheers
Rahul
IP IP Logged
mohamed_salafi8
Newbie
Newbie


Joined: 05 Feb 2008
Location: Saudi Arabia
Online Status: Offline
Posts: 17
Quote mohamed_salafi8 Replybullet Posted: 13 Jun 2008 at 7:50pm
thanks alot for your help
Regards
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.016 seconds.