i am using auto serial number in crystal report.but my problem how can ignore the serial number if come data is duplicate.
for ex:
EMP NAME
1 DR.M.M. SAHU
2 DR.M.M.SAHU
3 DR J.PANDA
4.DR S.NANDA
5.DR.S.NANDA
6.Mrs B.SINGHA
I want to result
EMP NAME
1 DR.M.M.SAHU
DR.M.M.SAHU
2.DR.J.PANDA
3.DR.S.NANDA
4.DR.S.NANDA
DR.S.NANDA
5.Mrs B.SINGHA
so please help me which formula or method use in this problem.