count the number of dates in a group 1

[scottaherbst]

Hi, I'm working with CR 10 on an SQL server database. I have generated a report that has four items in the details section: CustomerID, Service Type, Start Date, End Date. For some records there is no end date as services are ongoing. What I would like to do, is to have a summary field in a group that counts the number of closed services (whereever an end-date shows up). I tried to use a summary field and count, but it counts instances where there is no date. How do I write a formula or a custom summary that will only count when there is an occurence of a date? Thanks.

 

[synapsevampire]

A Running Total of:

count->date
reset->group
evaluate->use a formula:

not(isnull({table.date}))
and
{table.date} <> cdate(0,0,0)

-k