Good morning everyone. For the past few days I've been reading this site trying to understand crystal reports as this application is still new to me.

I am trying to get a number count on the number of tickets opened within the 48 hours. I have been unsuccessful in getting a ticket count.

So I have:

if {Incident.LastStatus} in ["Active", "Waiting", "Logged"] then
if {Incident.CreatedDateTime} < currentdate and minute({Incident.CreatedDateTime}) >= 2880   then
    
      count ({Incident.LastStatus})

I am not sure if the minute() function is used properly here.

Thank you.

As for counting them here are 3 main ways (assuming you do not have duplicate data rows that you have not mentioned):

Edited by DBlank - 18 Dec 2009 at 10:05am

Another question:

Would the dateadd() be the same for an overall date meaning I have a fixed date 1/1/2009(beginning of the year) to the currentdatetime?

That is correct. When I put the running total (named overall) I get 0 entries (Using code below):

{Incident.Source} in ["Logged", "Active","Waiting"] and
{Incident.CreatedDateTime} in YearToDate

Hmmm...I'm still receiving 0 as a total result. Why would I be able to retrieve data for the 48 hours but not for the beginning of the year?

Also, may you explain to me what the 1's and 0's are for?

{Incident.CreatedDateTime} in datetime(year(currentdate),1,1,0,0,0)

Thank you.