Sort report by event role and/or status
The default reporting does not cater for sorting status and role. One way to achieve this is by writing code as Pradeep suggested. Another way is to export the report data to Excel (csv) and do the sorting in Excel.