[RESOLVED] Need help about crystal report record number

[morbid.ivan]

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?

[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

[morbid.ivan]

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.

[jggtz]

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

[morbid.ivan]

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?

[jggtz]

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

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

it will count only 1 every group

[morbid.ivan]

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

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.

[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

[morbid.ivan]

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?

[jggtz]

what code should I use for the formula?

See post #6

[morbid.ivan]

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.

[jggtz]

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

[jggtz]

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

[morbid.ivan]

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 .