Crystal Reports & SQL Reporting Services Training Consultants
Account Log in:
Username:
Password:
Don't make the same mistake twice
 
Institute of IT Trainers - Freelance Trainer of the Year 2006 & 2009
Liverpool Business Connect Member
  Maximum Impact Solutions Limited - Reporting Solutions, Creating Answers
Reporting Solutions - Creating Answers, Crystal Reports, Dashboarding (Xcelsius) & SQL Reporting Services

The Maximum Impact Solutions Blog Feed ME!!!!

24
November

How Do I Sort the Group Summary in Crystal Reports?

A client recently asked "How do I sort a report by the group summary in descending order in Crystal Reports?"

When groups are added to a report Crystal Reports sorts the group name in one of 4 ways:

  • Ascending Order,

  • Descending Order,

  • Original Order, or

  • In Specified Order


To sort a report by the summary field, one has to use the Group Sort Expert feature of the Crystal Reports

  1. Create the report
  2. Add the required group(s) to the report
  3. Add the required Summary field(s) to the Group Header/Footer section
  4. From the Report Menu select the Group Sort Expert option
  5. In the Group Sort Expert dialog box:

    • Select the required Group Field
    • From the For this Group Sort drop down select All
    • Select the required summary field to sort by
    • Select the sort direction of the Summary field:

    Crystal Reports Group Sort Expert dialog box

    • Press the OK button
1

Teri

18
July
Exactly what I was looking for, works great! Thank you!!
2

Erik

09
November
THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU !!!!!!!!!!!!!!!!!!!! !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
3

Tahir

28
November
Thank you very much. its works and solved my problem.
4

ranga

22
December
thanks i do that

MAKE A COMMENT

Name *

Email Address *

Comment *