Label Parameters and Distinct

[mholbert]

I am using Cr9 against a sql2k db. I am building a label report to generate patient labels. The scenario is when a doctor leaves, we need to be able to query the database and print one label for each patient who has been to see that doctor in a given period of time.

I built the report, and requested distinct records, but because of the date range parameter, it is still returning duplicate patients.

Any thoughts on how to make it return each patient only once?

MH

 

[Madawc]

Group by patient number, whatever it is you use. Show the label details in group header or footer. Suppress the detail lines.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[mholbert]

I considered doing that, but it defeats the label functionality in CR.

Thanks, M