Hi Haris,
Create Groups for the field which holds the value for
Accepted,
Rejected,
Hold
once the group is created
Customize the group
Go to reports Group Expert,Select Group Field
Click Options Button,then in Change Group Options Common tab
Select
in specified order
create the order as
Accepted,Rejected,Hold
then display the details for those specific groups.
Also don't forget to check the New Page After option for group footer which can be selected from section expert this displays the details for the specific groups only and starts on new page when the details for that group is finished priting in the report.
Cheers
Rahul