Suppressing repeated records in the query

Hello Gurus,

I have a Doctor#1 treating Patient#1 in 3 different cases and in the report I just need to see 1 instead of 3 as it is the same patient#1 to the same doctor#1. What are the ways I can manipulate this data without writing any program.

Report shows as follows: records

doctor 1 disease 1 patient 1 1

disease 2 patient 1 1

disease 3 patient 1 1

total 3

Any help i.e can I write conditions? Selections? or any idea would be greatly appreciated.

Thanks,

Priya