Group sorting

[Ofina]

In XI, can I group by one field, but sort those groups by another?

I want to group by invoice number, but sort the invoices by due date.

 

[briangriffin]

Create a group on due date, and select "The section will be printed" for each day.

Rearrange the groups so that due date is group 1, and invoice number is group 2.

Then suppress both group header and 1 and group footer 1. The report will appear to have just one group, invoice number, but the due date group will control the ordering.

 

[briangriffin]

Another approach would be to insert a summary in the invoice number group footer for the minimum of the due date (since the dates will all be the same, it won't matter if you use min or max). Then use the Group Sort Expert to sort all based on that summary value.

I think the hidden group approach is a little more flexible, but this should work equally well for what you describe.

 

[Ofina]

Thank you so much. Your first suggestion was perfect!