I would like to group by one field and sort by another field with Crystal Report.
For example: Group A
with PO Number
(sort ASC). For each PO Number, there is one Name with it and I would like to sort by Name_x
.
I have tried to add a field with Record sort Expert
or I created a new group with Name_x
and then sort by a new one but it does not work.
PO_1 Name_4
PO_2 Name_2
PO_3 Name_3
PO_4 Name_1
PO_5 Name_7
PO_6 Name_6
The result must be:
Name_1 PO_4
Name_2 PO_1
Name_3 PO_1
Name_4 PO_1
Name_6 PO_6
Name_7 PO_5
I've found the solution as below and it works pretty well. Please let me know if you have any idea.
Solution: We will create summaries within each group which we can use for the sort function.