By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,357 Members | 1,194 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,357 IT Pros & Developers. It's quick & easy.

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

P: n/a
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
Share this Question
Share on Google+
1 Reply

P: n/a
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.