CODEWITHSUNDEEP
c#crystal-reportsgrouping
Loyal
Loyal

Reputation: 823

Crystal Report Group Record Number

I am working on C# Crystal Report 2013. I want this type of report With serial number from 1 in each group. So how should I do this?

Group - Dept A
1 - 123 Abc
2 - 234 Xyz
3 - 445 Pqr

Group - Dept B
1 - 344 uuu
2 - 322 989

Upvotes: 5

Views: 22438

Answers (4)

Shiba Das
Shiba Das

Reputation: 369

place reset formula in the section you want to rest the serial count

@reset formula

Shared Numbervar count;
count:=0

@increment formula

Shared Numbervar count;
count:=count+1;
count;

@display group footer formula

Shared Numbervar count;
Shared Numbervar Count_Final;
Count_Final:=Count_Final+count;
count;

@final report footer formula
Shared Numbervar Count_Final;
Count_Final

Upvotes: 0

Ar Win
Ar Win

Reputation: 126

you can do it follow below way.

-Add running total field.

-Field to Summarize => a field of your group which you want to count

-Type of summary => Select "count".

-In evaluate select => For each Record

-Reset => On Change of Group (select your group)

-Place it on Details section

Upvotes: 5

syed
syed

Reputation: 31

  1. Add running total field. Give it proper name.

  2. Field to summarize : Select group column name to summarize.

  3. Type of summary : Select "count".

  4. In evaluate select "On Change of Group".

  5. Reset : select "Never".

Upvotes: 3

Siva
Siva

Reputation: 9091

you can do it follow below way.

create a formula @reset

Shared Numbervar count;
count:=0;

Place above formula in group header and group footer.

Create one more formula @Count to count and place it where requreid.

Shared Numbervar count;
count:=count+1;
count

Upvotes: 5

Related Questions