Crystal Report Group Record Number
Asked Answered
A

4

5

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 
Aquarium answered 6/2, 2015 at 9:56 Comment(2)
i have created groups but i want the numbering format that each group record should start from 1.Aquarium
Just create another group for Serial number under Dept group. And suppress the Details section. Place all fields on the Serial No group. You will get what you want.Crews
B
5

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
Burleson answered 6/2, 2015 at 10:23 Comment(0)
L
4

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

Librarianship answered 25/12, 2018 at 13:29 Comment(0)
P
3
  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".

Polypus answered 13/8, 2018 at 8:19 Comment(1)
Simple and Easy. Worked for me!Phyllisphylloclade
W
0

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
Wolsky answered 19/6, 2020 at 17:56 Comment(0)

© 2022 - 2024 — McMap. All rights reserved.