Can we change the order of the group in crystal report

Question

i am grouping the record by ordercode which is integer value as ascending order. But ordercode have zero(0) as one of the value. when i am grouping records by ordercode, it starts withs zero group as first. but i dont want to show zero group as first. can we do like order should be ascending order of ordercode except zero group and i want zero group at the end of the report?

Answer 1

You can use Specified order where you can specify as required or if you need 0 as the last group why don't you group descending order.

Answer 2

Create a formula field that will result in the sorting that you desire, then group the formula field.

For example:

If {table.order_code}=0 Then
  1000000000
Else
  {table.order_code}