[RESOLVED] Need help about crystal report record number

I NEED HELP ABOUT CRYSTAL REPORT RECORD NUMBER.

EXAMPLE :

1. BRYAN
2. VINCE
3. ROME
-. ROME - if name is duplicated, skip to next record
4. LETTY
5. MIA
-. MIA - if name is duplicated, skip to next record

How do i do something like this?

To eliminate the repeated record: Insert a Group on the field you want to manage and use the group header section instead of detail section
To count the records : You could use a formula field, a simple accumulator, and place it in the group header section

Quote:

---

Originally Posted by jggtz

To eliminate the repeated record: Insert a Group on the field you want to manage and use the group header section instead of detail section
To count the records : You could use a formula field, a simple accumulator, and place it in the group header section

---

is there any other solution? i dont know where to start.

https://www.google.com/#output=searc...w=1024&bih=625

Quote:

---

Originally Posted by jggtz

https://www.google.com/#output=searc...w=1024&bih=625

---

I have tried to experiment with these codes, it counts but not the first record, counting skips to second record.

BRYAN
1. VINCE
2. ROME
-. ROME
3. LETTY
4. MIA
-. MIA

FORMULA :

WHILEPRINTINGRECORDS;

NUMBERVAR CNT;

IF PREVIOUS({TBL_PAYROLL.NAME}) <> {TBL_PAYROLL.NAME} THEN
CNT:= CNT + 1

what's wrong with this?

...and what if you place the formula in the group header section

Code:

---

WHILEPRINTINGRECORDS;
NUMBERVAR CNT;
CNT:= CNT + 1;

---

it will count only 1 every group

Quote:

---

Originally Posted by jggtz

...and what if you place the formula in the group header section

Code:

---

WHILEPRINTINGRECORDS;
NUMBERVAR CNT;
CNT:= CNT + 1;

---

it will count only 1 every group

---

It needs to be count on details section and skip duplicates but duplicated records needs to show.

No, you need to count on every header group section
...place the formula on details section
...and check "Suppress If Duplicated Display String" in Common tab from Format Editor dialog window

Quote:

---

Originally Posted by jggtz

No, you need to count on every header group section
...place the formula on details section
...and check "Suppress If Duplicated Display String" in Common tab from Format Editor dialog window

---

what code should I use for the formula?

Quote:

---

Originally Posted by morbid.ivan

what code should I use for the formula?

---

See post #6

Quote:

---

Originally Posted by jggtz

See post #6

---

Can you please see the attached file and see what's wrong with it.

I hope you can help me. Thanks in advance.

Sorry morbid.ivan but my antivirus does not let download your attachment!

Here goes a small example
It's resolved using RunningTotal field ...but we need to group the records

Quote:

---

Originally Posted by jggtz

Here goes a small example
It's resolved using RunningTotal field ...but we need to group the records

---

Thank you. You're a big help .