sortingcrystal-reports

How to group by one field and sort by another field with Crystal Report


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

Solution

  • 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.