Print Page | Close Window

Custom Group Based on Group Sum

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2016
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=22682
Printed Date: 25 Jun 2019 at 9:42pm


Topic: Custom Group Based on Group Sum
Posted By: igendreau
Subject: Custom Group Based on Group Sum
Date Posted: 16 Oct 2018 at 5:32am
I'm grouping sales numbers, and I want to do something like determine whether a number is 0-50K, 50k-99k, or 100k+. I know I could do a custom group to handle that on the detail level.

The challenge is that I want to custom group other groups. On the detail level, I have each individual sale. Those detailed records are grouped by customer, and that group has a sum of all the sales. What I want to do is group each customer into one of my 3 categories. So I'd be using the group sum number as my qualifier for which group they go in, which Crystal doesn't want to let me do.

Any good way to accomplish this?



Replies:
Posted By: kevlray
Date Posted: 16 Oct 2018 at 7:37am
Maybe, formulas are done before grouping.  The sum would have to be in a formula (never tried this, hopefully it will work).



Print Page | Close Window