Crystal Report how to change the display order in a group

4
votes

I have a crystal report like below image:

enter image description here

The report is group by "Quot No.", by default it's ordered by "Times Used" (8th column)

How can I change the ordering so that it will order by "Total amount"?

The total amount is a field in the report which is the sum of a field named "quotamt" in the datasource:

enter image description here

I've tried looking in the change group options, took a look at the "Use a formula as group sort order", but the formula only provides three options (ascending, descending, original order), and is unable to sort by another column

enter image description here

The desired result is:

enter image description here

How can I do that?

2
crystal-reports
It is needed on conditional basis or permanent. – Ajay2707
@Ajay2707 it's needed on conditional basis – User2012384

2 Answers

3
votes

What I suggest, rather than doing this task in crystal report, good to done at sqlserver side means database side.

This is simplest suggestion when you have this type of situation.

You can give the condition on sqlserver side too. and get the data order same as you want.

Yes, this can be done in report side, but it take time for this.

1
votes

Don't use formula as group sort order instead from the dropdown use Specifed Order and in the window specify the order you need