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
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
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
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
Add running total field. Give it proper name.
Field to summarize : Select group column name to summarize.
Type of summary : Select "count".
In evaluate select "On Change of Group".
Reset : select "Never".
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
© 2022 - 2024 — McMap. All rights reserved.