Sorting and Groups

[crywrite]

I have a report that I want to run for a salesman. I want to total/group all sales dollars by customer, but sort the customers by sales amount, the greatest being first. How do I still group and total my dollars by customer and have my sales amount sort? If I add a sales amount group above the customer group, it breaks up the customer sales. And I am unable to create a group on a subtotaled field (of total sales amount, by customer). How can I go about this?

 

[IdoMillet]

Group and total by Customer.

Then, use the menu choice of:
Report, TopN/Sort Group Expert...
to sort the Customers by their total amount.

Cheers,
- Ido CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[crywrite]

Thank you. That worked perfectly!