Grouping Intervals
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
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=2389
Printed Date: 19 May 2024 at 3:47am
Topic: Grouping Intervals
Posted By: LotMan
Subject: Grouping Intervals
Date Posted: 20 Feb 2008 at 10:55am
|
I am trying to set up groups for a clients last years sales based on a summary of all invoice totals from last year. I know I can do this if I have a datafield that has this total sales amount, but how do I do this off of a summary I created?
|
Replies:
Posted By: BrianBischof
Date Posted: 21 Feb 2008 at 6:38pm
Unfortunately, you can't do it based on a summary field b/c the summary field is calculated at the same time that the groups are created. So the summary field data isn't actually available b/c it's still in the process of being calculated.
-------------
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
|
Posted By: LotMan
Date Posted: 22 Feb 2008 at 8:23am
|
do you know of any way around this?
|
Posted By: mpalecek
Date Posted: 28 Feb 2008 at 9:55am
|
I beleieve the best way to do this would be to create multiple SUM fields. So you have the summary of the invoice lines to create the invoice total, and then do another summary of the invoice lines to create the client total. You could then go on to create a summary of the entire report.
|
|