sort by running totals 1

[adhhealth]

crystal reports 8 pervasive sql 8

I have a report like this

prodcode description no. of orders

1122 abc 349
1234 def 22
2344 xyz 1289


report is grouped by
1. prodcode
2. batchnumber

no. or orders- is the running total of count of batch numbers..

i have the above details in the group footer of prodcode.

Now I want to sort the report in ascending order of the running total

prodcode description no. of orders
1234 def 22
1122 abc 349
2344 xyz 1289

how can we do this?

 

[bdreed35]

You won't be able to sort the report by a running total.
Post what your doing in the running totals. You may be able to convert them to straight summaries with which you can sort the groups with using the Group Sort Expert.

~Brian

 

[Madawc]

As bdreed35 says, you are trying to get Crystal to do something it isn't built for. It works by fixed cycles: summary totals come directly from the data and can be used to control the order in which things are printed, and even whether they are printed. Running totals are totted up at the same time as printing and so can't be known in advance.

Both sorts of total may be applied to a field by right-clciking and then choosing [Insert].

Madawc Williams (East Anglia, UK)

 

[adhhealth]

Thanks Brian and Madawc for the advise..
as Brian suggested i created straight summaries rather than running totals by moving around a few things in the report and then sorted using group expert
thanks again.