Group by One Field Sort by Another

Printed From: Crystal Reports Book — Forum Name: Report Design

Posted By: BernieHunt — 4 Nov 2008 at 3:37pm

I have a report of patient statements. Each patient's data is tracked by their PatientID. Crystal Groups on the PatientID field. At the end of each ID is a new page.

I'd like to sort the statements by a different field. For example the Last Name. When I look into the Record Sort Expert, it won't let me put the Last Name field as a higher sorting priority than the PatientID.

How do I sort by a field other than my Group Sort?

Also, is there a way to keep Crystal from sorting and let me sort the dataset before giving it to Crystal?

Thanks,

Bernie

Posted By: jonberardi — 6 Nov 2008 at 10:08am

I have the exact same question. I am grouping records by UserID and need it sorted by Last Name.

Any help is greatly appreciated!

- Jon

Posted By: BernieHunt — 9 Nov 2008 at 7:03pm

I didn't find a way in Crystal, but I found what I think is a better way for me. If you open the Group Expert and in the right pane select the group you are sorting by. Click the options button to see the Change Group Options dialog. The second drop down box is the order selection. Change that to "in original order".

This returns control of the sort order to your code. You can sort your data any way you want in the dataset and then hand it to Crystal. Crystal will group by the field you selected, but the sorting is what you gave it.

This what I've found works for me, but I haven't heard from anyone else on the subject.

Bernie

Posted By: Pradeep1210 — 30 Jun 2011 at 4:14am

Please have a look here for a possible solution:
http://pradeep1210.wordpress.com/2010/04/07/grouping-on-one-field-and-sorting-on-another-in-crystal-reports/

Edited by Pradeep1210 - 30 Jun 2011 at 4:16am

Posted By: shortwrite — 14 Sep 2011 at 6:07am

BRILLIANT!! I read your solution, and it worked for me... I am relatively new, and have had no training... (OTJ only)

THANKS!

Posted By: jorrebor — 23 Nov 2011 at 4:39am

How about interactive sorting?

Once i present crystal with an ordered list, the interactive sort control (on the other field) destroys the original order.

I would like to add 2 interactive sort controls without grouping. Any ideas on this?

thanks!