report sumary and top 20 medical proecudres

[nfldbunker]

hi

i want to create a summary report based on procedural or diagnosis information showing summary totals based on institution and year in one part of the report and the top 20 proedure or 20 diagnosis in another part of the report.

any ideas or suggestions and or steps to follow would be appreciated

bunker

[blom0344]

I'd say you need at least 2 seperate queries. First query for the aggregated data and a second one that ranks and filter the top xxx detail data. Showing either top 20 procedure / top 20 diagnosis may involve yet another query split and using conditional blocks or pages to show either one in the report.