Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Summary or Running total? Post Reply Post New Topic
Author Message
Lunchbox
Newbie
Newbie
Avatar

Joined: 27 Aug 2007
Location: United States
Online Status: Offline
Posts: 2
Quote Lunchbox Replybullet Topic: Summary or Running total?
    Posted: 27 Aug 2007 at 10:37am
I have a running total set up that tallies the hours for a given employee based on the week, so it adds the hours that week for a running total, then resets and starts from zero, tallies for that week for a running total, etc.  I want to have the report display just the highest value before the running total resets for the following week.  Should I even be using a running total at all or should I try a summary?
I am most confused.

Thanks for any help.

IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 28 Aug 2007 at 7:38am
This would be a good place to use a summary instead of a running total if you are grouping by week.  Summary functions can only be calculated at the group and report level.  Running totals can be reset on conditions that have nothing to do with the groups.
 
-Dell
IP IP Logged
Lunchbox
Newbie
Newbie
Avatar

Joined: 27 Aug 2007
Location: United States
Online Status: Offline
Posts: 2
Quote Lunchbox Replybullet Posted: 28 Aug 2007 at 7:58am
Actually a Cross-Tab report gives me exactly what I need in exactly the format I need already.

Thanks for the reply though.   Thumbs%20Up
IP IP Logged
Post Reply Post New Topic
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



This page was generated in 0.031 seconds.