Print Page | Close Window

Sorting on Percentages calc'd in a footer line

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Tips and Tricks
Forum Discription: Have you learned some great tricks to share with the group? Post them here!
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=14546
Printed Date: 02 May 2025 at 12:26pm


Topic: Sorting on Percentages calc'd in a footer line
Posted By: venham
Subject: Sorting on Percentages calc'd in a footer line
Date Posted: 29 Sep 2011 at 10:04am
I have created a percentage field as a formula in the footer line of a group and would like to sort the report in descending sequence by that percentage. 
 
My control break is governed by the customer number and so I am unable (or don't know how) to create a group sort by something other than customer.
 
Any help would be big boon!



Replies:
Posted By: DBlank
Date Posted: 29 Sep 2011 at 10:22am
as far as I know this can only be done if you use an insert summary function and then use Group Sort Expert (top N sorting)



Print Page | Close Window