Using Crystal Report 8.5
Example
Personid Date
3100 22-02-2009
3100 22-02-2009
3100 22-02-2009
3200 22-02-2009
3200 22-02-2009
3200 22-02-2009
3200 22-02-2009
3100 23-02-2009
3100 23-02-2009
3100 23-02-2009
3100 23-02-2009
3200 23-02-2009
3200 23-02-2009
3200 23-02-2009
3200 23-02-2009
So on…,
Expeceted Output
Personid Date
3100 22-02-2009
3100 23-02-2009
3200 22-02-2009
3200 23-02-2009
So on…,
Date should appear only once for the personid. But I am getting duplicate record from the database. Date is displaying again and again for the personid.
How to skip the duplicate record. Can any one help to solve this problem.
Need crystal report Formula Help.
Best Answer
You should be able to group by PersonID and then by Date, move the fields from the details section to the Date group footer and then suppress the Details, PersonID Header and Footer, and Date Header so that the Date Footer works as your details row. Doing this will only show one row for each PersonID and Date combination. Hope that helps.
Edit: Each group header and footer only displays once for each change of the value. Therefore in your example if you didn't suppress any sections you'd have something like the following:
Therfore if you hide all of the sections except for the GF2 sections you'd get: