Use of top N sort 1

[whimple]

I am working on a report to show the n most used diagnoses in a medical clinic. I need to show the n most used diagnoses for a given reason for visit (RFV). The RFV for each visit is in one table, and the diagnoses used for each visit are in another table, linked by a unique visit ID number. Each visit will have one RFV, but may have several diagnoses used. I am thinking that the top N sort would be appropriate, but I am having trouble applying it to this situation (newbie that I am). Any ideas on how to approach this, whether by top n sort or any other method?
Thanks in advance to anyone who replies!

 

[kenhamady]

TopN is what you want.
1) Group by Reason
2) Group by Diagnosis within Reason.
3) Add a summary that counts the visits by Reason
4) Add a summary that counts the visits by Diagnosis within Reason.
5) Then do a TopN of the Diagnosis count. You can set N to be any number, and it will only show the TopN within each RFV. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com