?
Solved

How to sort group by different field in Crystal Reports

Posted on 2014-03-31
5
Medium Priority
?
2,781 Views
Last Modified: 2014-04-07
I have a Crystal Report that groups by an identifier field but I want it to sort by a different field. There is always a one to one relationship between the identifier field and the sort order field.
0
Comment
Question by:Morgs77
5 Comments
 
LVL 34

Assisted Solution

by:Brian Crowe
Brian Crowe earned 600 total points
ID: 39966499
Why can't you just group by the "different" field?
0
 
LVL 35

Accepted Solution

by:
James0628 earned 900 total points
ID: 39968907
If it really is one to one, then I agree, it seems like you could just group by the other field.  But if you can't, or don't want to, do that for some reason ...

 What version of CR are you using?  I think some of them may have an option in the group options to change the sort order.  I'm using CR 10 and it does not have that option, but I think later versions may.

 Otherwise, the usual way to handle this would be to group by the other field first, and then your current field.  You can suppress the extra group header and footer if you like.  I suppose a potential down side to this is that the values for the sorting group will be shown in the group tree.  I don't know of any way to get around that.

 James
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 39976964
WHile it makes sense to group by the other field you can try this idea

Put the field on the report in the detail section
Right click the field
Click INSERT ==> SUMMARY
Set the summary to be MAXIMUM
Set it to insert in the group footer
Click OK

Click REPORT  -->  GROUP SORT OPTIONS
Set for ALL RECORDS
Choose the Summary field

mlmcc
1
 

Author Closing Comment

by:Morgs77
ID: 39980538
Thanks for the help. It was all complicated by hierarchical grouping which didn't work properly when grouping by the 'other field' first. I managed to get around this with a few adjustments to the SQL View.

Works great now. Thanks.
0
 
LVL 35

Expert Comment

by:James0628
ID: 39984075
Ah.  I've never used hierarchical grouping, so I'm not sure how that would affect things.  I'm glad you were able to figure it out, and glad I could help.

 James
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Ready to get certified? Check out some courses that help you prepare for third-party exams.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Viewers will learn how the fundamental information of how to create a table.
Suggested Courses

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question