Sort on manually computed group total

[jigitty]

Hi,

I am using CR 9.0. In report of Vendors and their Orders I have grouping on Vendor Name:
Details section : Order ID and order amount(using complex formula).
Group 1 footer : Vendor Name and total order amount for that Vendor

Now I want to generate a report which contains only Vendor Name and Total Order Amount in descending order of Total Order Amount.

The total order amount is a manual running total and hence it is not available in the Group/Sort Expert.

Which choices do I have to be able to achieve the above?

Thanks,
Jigitty.

 

[Ngolem]

Use a TopN sort...this is your only choice....other than a much more complicated....capture values in an array or two,
sort them and display in a report footer


Jim Broadbent

 

[jigitty]

Jim,

Thanks for your reply.

TopN sort is not available as the amt field is a manual value(computed off of complex logic in a sub-report embedded in the main report header).

Arrays have a limitation of 1000 elements. Hence I can't use those either.

Sincerely,
jigitty.