Solved

How to sort group by different field in Crystal Reports

Posted on 2014-03-31
5
2,015 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
ID: 39966499
Why can't you just group by the "different" field?
0
 
LVL 34

Accepted Solution

by:
James0628 earned 300 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 100

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
0
 

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 34

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

[Webinar] Disaster Recovery and Cloud Management

Learn from Unigma and CloudBerry industry veterans which providers are best for certain use cases and how to lower cloud costs, how to grow your Managed Services practice in IaaS clouds, and how to utilize public cloud for Disaster Recovery

Question has a verified solution.

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

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 …
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

911 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

28 Experts available now in Live!

Get 1:1 Help Now