Sort order

[Wolfgang]

Hello,__I want to sort a database by the amounts of records in each group.__How can I do that?__Is it possible to take a total field as a sort field?__Thanks__Wolfgang

[kfleming]

You can create a group total and make it pre-processed. It will then be available as a sort field.__So if you are sorting and grouping by customer and want to see the customers in descending order by total sales, you would create a total that sums order value and resets by customer and make it pre-processed.__You would then change the sort order from customer to the customer total descending. The group field will stay as customer.____Kathleen__R&R Support

[Wolfgang]

Hello,__that works only when I for example sum a numeric field like:__new: Sum(MECHMIN1, MUSTER, Automatic, Preprocessed, Condition)____but not when I want to count the records__new: Count(Recno_rr, MUSTER, Automatic, Preprocessed, Condition)__I can not see the field in the table "Select Sort Field".__Wolfgang

[Wolfgang]

Count a field from the table rather than recno() and it should then appear in the list.__Recno() is a special function in R&R.______Kathleen__R&R Support

[kfleming]

>You can create a group total and make it pre-processed. It __>will then be available as a sort field. __>So if you are sorting and grouping by customer and want to __>see the customers in descending order by total sales, you __>would create a total that sums order value and resets by __>customer and make it pre-processed. __>You would then change the sort order from customer to the __>customer total descending. The group field will stay as __>customer. __>__>Kathleen __>R&R Support __