Top 10 Report based on Diagnosis with associated LOS(Length of Stay)

[nfldbunker]

HI Everyone

Just wondering how i would approach developing a report for the top 10 or 20 diagnosis and some associated data such as length of stay, procedure etc.

please provide some details if possible.

regards

nfldbunker

 

[cschnu]

HI Everyone

Just wondering how i would approach developing a report for the top 10 or 20 diagnosis and some associated data such as length of stay, procedure etc.

please provide some details if possible.

regards

nfldbunker
 

Not really sure what you are asking, my guess is you need to look into grouping your data and then limiting your query to 10 or 20 rows.