470,641 Members | 1,472 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,641 developers. It's quick & easy.

Report Writer question: can I do a "top ten"

ED
I created a query with my detail data, but am struggling with the report
writer. Any help would be appreciated!

I have the first grouping "Service Line" and then second grouping
"Physician" My third group-by is "DRG" and the number of cases for each
DRG. This DRG is what I have in the detail section of the report. However,
I just want to show the top ten (or less if a doctor has less than ten
unique DRGs) for each Physician.

I can not find how to do row limits or anything like this in report writer,
although I used to use similar features years ago in Crystal Reports.

Thanks!

ED
Nov 12 '05 #1
1 1653
On Sat, 13 Dec 2003 17:50:05 GMT, "ED" <ea*********@hotmail.com>
wrote:

You will find a Top 10 option in the properties for the query itself,
not in the report writer.

-Tom.

I created a query with my detail data, but am struggling with the report
writer. Any help would be appreciated!

I have the first grouping "Service Line" and then second grouping
"Physician" My third group-by is "DRG" and the number of cases for each
DRG. This DRG is what I have in the detail section of the report. However,
I just want to show the top ten (or less if a doctor has less than ten
unique DRGs) for each Physician.

I can not find how to do row limits or anything like this in report writer,
although I used to use similar features years ago in Crystal Reports.

Thanks!

ED


Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

19 posts views Thread by Mason A. Clark | last post: by
6 posts views Thread by Mason A. Clark | last post: by
16 posts views Thread by Gufus | last post: by
16 posts views Thread by J. C. Denton | last post: by
1 post views Thread by sheldonlg | last post: by
???
1 post views Thread by Stoney L | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.