CODEWITHSUNDEEP
crystal-reports
User2012384
User2012384

Reputation: 4919

Crystal Report how to change the display order in a group

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?

Upvotes: 4

Views: 7850

Answers (2)

Ajay2707
Ajay2707

Reputation: 5798

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.

Upvotes: 3

Siva
Siva

Reputation: 9101

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

Upvotes: 1

Related Questions