Date parameter over date range with running totals

[SaraJB]

Hi

I'm using crystal 8.5 and have created 3 running totals all using formulas to evaluate;

#cases opened in mth = {@Received date}in{?FromReceivedDate}to{?ToReceivedDate}
#open and closed={@Received date}in{?FromReceivedDate}to{?ToReceivedDate}
and
{CM_COMPLETED_CASE.COMPLETIONDATE} in{?FromReceivedDate}to{?ToReceivedDate}
#cases still open mth end={@Received date}in{?FromReceivedDate}to{?ToReceivedDate}
and
not ({CM_COMPLETED_CASE.COMPLETIONDATE} in DateTime ({?FromReceivedDate}) to DateTime ({?ToReceivedDate}))

The reports grouped by the Received Date and by the userid as there's also a count for cases close per user.

There's also a date range parameter for received date and the problem is when the date range is for just one month there are values for all 3 running totals (which is what I would expect), but when you run for a date range the 3rd running total is always zero for each month.
Do you know why this is?
Help much appreciated.

Thanks
Sara

 

[Naith]

Just out of curiosity, why have you converted the parameters in the last part of the last formula, but not anywhere else?

Naith

 

[SaraJB]

Hi

I've been playing around with different things so don't think they should be there, error on my part.
Would this be part of the problem?

Sara

 

[SaraJB]

Just removed and the problem is the same.

 

[synapsevampire]

What's in @received date?

You might try adding this, the problem may be that they're null:

(
not ({CM_COMPLETED_CASE.COMPLETIONDATE} in DateTime ({?FromReceivedDate}) to DateTime ({?ToReceivedDate}))

or

isnull({CM_COMPLETED_CASE.COMPLETIONDATE})

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com