Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations sizbut on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Count or suppress Records

Status
Not open for further replies.

rekhatr10

Programmer
Apr 2, 2004
67
US
Hi Everyone,

CR 7.0
I have a report where I am dipslaying whethter the residents' and the prectors created notes on the patient they saw. I just want to display for an account only 2 records. If they have more than 2 records I am assuming that they have a preceptor and the attending docotor's note. How can I suppress or count records in detail section to only show those accounts which has only 2 records in docnotes tables.


Thank you
Rekha
 
In Crystal 8.5, you could set a summary count on a field, grouped by account. Then use a suppression formula to suppress accounts with more than two.

Quite how you'd do this for Crystal 7, I'm not sure.

Madawc Williams
East Anglia, Great Britain
 
Madawc,

Crystal 7.0 has the same thing. I got it working

Thank you
Rekha
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top