Joined: 20 Feb 2008
Online Status: Offline
Posts: 3
Topic: Grouping Intervals 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?
Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
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>
Joined: 28 Feb 2008
Location: United States
Online Status: Offline
Posts: 9
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.
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
IP Logged
