Click to See Complete Forum and Search --> : Sorting by group count


achuzan
June 1st, 2009, 09:49 AM
Hello, I am very new to Crystal reports.
I have a report that I have grouped by one column. And I have a count of records in each group. Is it possible to sort the report on the count of records in each group?
For example

Phone number Num of times called (counting records in group)
Rec 1 : 555-5555 3
Rec 2 : 444-5555 5
Rec 3 : 333-5555 2

I would like to be

Rec 2 : 444-5555 5
Rec 1 : 555-5555 3
Rec 3 : 333-5555 2


Thank you.

jawadhashmi
June 3rd, 2009, 01:17 AM
Yes you can,

Group on the formula filed and put your ligic in the formula field. and as well mention the sort order as well.