Crystal Report Custom Sort

[babithac]

Hi I am new to crystal world.I my report I have 3 groups.
Line of business,cost center and object account.On the break of object account I need to display the credit and debit amounts,Object account.When the groups are in ascending order I have a record 11117 comming as the first record.But without making other objecta ccounts descending I want to send 11117(always)as the last record for each line of business.
Any ideas?

 

[IanWaterman]

Use a formula

@sort

If {objectacc} = 11117 then 99999999 else {objectacc}

Group on this formula ascending, remove group name from report and replace with field {objectacc}

Ian