Solved

How to sort group by different field in Crystal Reports

Posted on 2014-03-31
5
1,925 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 200 total points
Comment Utility
Why can't you just group by the "different" field?
0
 
LVL 34

Accepted Solution

by:
James0628 earned 300 total points
Comment Utility
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 100

Expert Comment

by:mlmcc
Comment Utility
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
0
 

Author Closing Comment

by:Morgs77
Comment Utility
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 34

Expert Comment

by:James0628
Comment Utility
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

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

763 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

Need Help in Real-Time?

Connect with top rated Experts

7 Experts available now in Live!

Get 1:1 Help Now