Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Sorting by summary

Status
Not open for further replies.
ij76

ij76

Technical User
Mar 15, 2005
25
CA
In Cyrstal v.9:

I have a report with groups of customers. For each customer I have a summary of total hours. I would like to sort my report from highest to lowest hours, not by customer name. Of course, I can't remove the group in the sort expert and can't move the summary ahead of the group for summary order.
 
Sort by date Sort by votes
Go to report->topN/group sort and select "sum of hours" as your sort field, descending.

-LB
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

socalvelo
  • Locked
  • Question
Group Sorting Distinct Count Minimum
Replies
2
Views
275
socalvelo
socalvelo
Insulations504
  • Locked
  • Question
why is my result getting multiplied by 17??
Replies
7
Views
348
pmax9999
pmax9999
Hellak
  • Locked
  • Question
Simple report - filtering by comparing two fields
Replies
1
Views
216
pmax9999
pmax9999
jlr123
  • Locked
  • Question
date range group by month 1
Replies
8
Views
294
jlr123
jlr123
trwebster
  • Locked
  • Question
Summary on non-recurring field error
Replies
1
Views
131
kray4660
kray4660

Part and Inventory Search

Sponsor

Back
Top