Different counts needed 1

[lholodnak]

I'm using crystal 9.0 that accesses oracle tables for the data. I have a report that I need to distinct count the total number of service requests numbers that were opened for a start and end date, I have start and end date parameters setup in my report. But then I need to count how many work orders (that meet a selected criteria such as "RPR") were completed during the same start and end date parameter. We have many work orders tied to one service requests so I using Work Order comp date - Srv Req Start Date to get a count of work orders completed. I just can't seem to get this right. Thanks for your help.

 

[lbass]

I think you could use a formula like:

if not isnull({table.wocompldate}) and
{table.criterion} = "RPR" then 1 else 0

Then right click and insert a summary (SUM, not count) on this formula.

-LB