In this case I will have to create manual running totals. I can't create a "BobTime", "JackTime" etc. variable since I will have no idea how many agents--could be 3 or 50. I assume I would have to use an array or something. What is the best way to do this? (With codes samples) I am using Crystal Reports 2008, and have no access to do anything on the database side.
Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Posted: 22 Jul 2015 at 11:11am
First off, do you need to see the details? If no, then group by agent. If yes, then you may be able to do an array (limit of 100 items). Since you are doing a time difference, you probably will need to do a manual running total.
GH: formula, Initialize running total (i.e, shared total :=0;) and any other variables needed.
Detail: formula, calc difference and add to previous value, Since there are comes and goes events, probably will need some logic to only calc when you have a goes event (storing comes event time in shared variable).
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