CODEWITHSUNDEEP
crystal-reportscrystal-reports-2008crystal-reports-xicrystal-reports-2010crystal-reports-8.5
user3145218
user3145218

Reputation: 43

Can we change the order of the group in crystal report

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?

Upvotes: 0

Views: 873

Answers (2)

craig
craig

Reputation: 26262

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}

Upvotes: 1

Siva
Siva

Reputation: 9101

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.

Upvotes: 0

Related Questions