Loading

Supress a duplicated value in crystal report

sam

16y4.2k

Hi.
I m doing a crystal report.
Lets say i have a serial numbers in a column:
| Serial Number |
124000100,124000101,124000102,124000103,124000104,

I wan the values to be something like this in the crystal report view
| Serial Number |
<124000>
100,101,102,103,104

means that the same value infront is grouped,categorized under one duplicate value.

How may i do this?
Any ideas guys?

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

sam16y ago
I dont understand the formula thing.
Do we need to apply the formula or something?
How to do that?
0
Ankur Gupta16y ago
Hello Sam
you can use 2 crystal report formula to do this.
in first formula get substring of serial number Left(6) and put it in the group clause.
and in second formula use Right(3) and put it in detail section.
I hope this will work.........
let me know if u have any issue.
0