Select Unique Clients

[Rich24]

Hi all,

I am new to CR (v.XI), so please go easy on me. I am using this report to pull clients seen in our clinic during the date range listed, but I only need them listed once. Here's the Show SQL Query from the Database menu:

SELECT encounter.servdate, encounter.clinic, patient.patno, patient.address, patient.city, patient.zip, patient.chartno
FROM cobb:informix.patient patient, cobb:informix.encounter encounter
WHERE (patient.patno=encounter.patno) AND patient.chartno<>'' AND encounter.servdate>{ts '2005-05-01 00:00:00'}
ORDER BY encounter.clinic, patient.patno

I'm sure there's an easy way to do this. Any help would be appreciated!

Thanks, Rich

 

[lbass]

Insert a group on clinic, then another group on patient number. Place the patient fields in the patient group header and then suppress the detail and group footer section.

-LB

 

[Rich24]

LB,

That worked just great!! Thank you very much. Could you recommend a good beginner's guide to CR-XI? I have a little experience with SQL and Access, but not enough to be good at either.

Thanks again, Rich

 

[lbass]

The George Peck books, The Complete Reference: Crystal Reports (version #) are good, as are Ken Hamady's guides. The CR help files are good, also. Or you can learn a lot just from following the threads here.

-LB

 

[Rich24]

Once again, Thanks!!