Crystal Reports Sorting on Percentages calc'd in a footer line

Tips and Tricks

Crystal Reports Forum : Crystal Reports 9 through 2022 : Tips and Tricks

Topic: Sorting on Percentages calc'd in a footer line

Post Reply

Post New Topic

Author	Message
venham Newbie Joined: 28 Sep 2011 Location: Canada Online Status: Offline Posts: 11	Topic: Sorting on Percentages calc'd in a footer line 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!
	IP Logged


DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	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)
	IP Logged

Printable version

Printable version

Forum Jump

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum