Separate sorting for each change of group

[Almie]

I am using Crystal 10, and was wondering if anyone knew how to perform separate sorting for each change of group. Let me explain.

group1: foreignkey_violation_records
cog1 - eventledger_bond_type - records with invalid bond types, need it to sort/group bond type alphabetically
cog2 - eventledger_case_status -records with invalid case status, need it to sort/group records case status alphabetically
cog3 - eventledger_party_type - record with invalid party types, need it to sort/group party type alphabetically

* cog - Change of group

Currently when I sort by bond type, all records appearing under the eventledger_case_status are sorted by bond type and so on for all other change of group records.

 

[kskid]

I would probably create a subreport for each change of group.

 

[Almie]

I was hoping there was another way. Thank you for your assistance.

 

[lbass]

Yes, you can do this. If your groupfield is {table.cog} with instances like cog1, cog2, cog3, set up a formula {@sort} like this:

select {table.cog}
Case "cog1" : {eventledger_bond_type}
Case "cog2" : {eventledger_case_status}
Case "c0g3" : {eventledger_party_type}

Then go to report->sort records and add {@sort} ascending as your sort field.

-LB