Tips and Tricks
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Tips and Tricks
Message Icon Topic: time and minutes Post Reply Post New Topic
Author Message
ciheaka
Newbie
Newbie


Joined: 05 Feb 2010
Location: United States
Online Status: Offline
Posts: 1
Quote ciheaka Replybullet Topic: time and minutes
    Posted: 16 Feb 2010 at 2:58pm

I am working on a report in Crystal and trying to do the following: obtain the number of cases performed from 11pm to 3am and then from 3am to 7am

I would also like to know how many minutes were performed on each case and how many cases were perfromed. There will be date parameters.

Can anyone please tell me the formula?

 
 
Thanks.
 
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 19 Feb 2010 at 7:11am
no one can tell you the formula, we don't know the data or the report.
I would use variables and every time a detail line is printed, I would check the time stamp and determine which bucket(variable) to increment. 
 
that would be the basis of the report changes that you requested.  Then in the group footer or whichever footer you want, I would reiterate the current values of the variables and reset them as needed.  There may be a whole host of variables tracking different groupings data and being updated/reset as needed.
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.023 seconds.