Print Page | Close Window

Sorting on Formula within a grou[

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=17522
Printed Date: 03 May 2024 at 10:40am


Topic: Sorting on Formula within a grou[
Posted By: benbpayne
Subject: Sorting on Formula within a grou[
Date Posted: 10 Sep 2012 at 5:39am
Hi There

I have a group of sales agents showing there weekly activity. I can sort the sales agent alphabetically or by gross sales or any field within my data really except by formulas I have created

I have calculated the average sales order value, Gross Sales/Number of Sales and want to sort by this calculation. I have tried all the obvious avenues but could someone point me in the right direction?

Much Appreciated


Replies:
Posted By: DBlank
Date Posted: 11 Sep 2012 at 4:06am
you can only group sort using summaries that are created using the "insert summary" function (or an equivalent written formula).
If you can alter you rapproach to getting a row level value that can have the insert summary function used on it then you can sort by it.


Print Page | Close Window