Odd date grouping request 1

[ddrake]

Okay...here's a stumper...for me anyway

I need to create a report that shows when callers call in again within 5 days of their original call (same issue recurrence).

I have a username, resolved date and category fields to work with. So in other words if 'username' A calls in again within 5 days of the original cases resolved date, in the same category, need to display that information.

Using CR9 and hitting a SQL2K box. Any hints to get this thing started would be greatly appreciated. Thanks!

 

[Madawc]

In Crystal 8.5, you could use something like

If username = previous(username)
and datediff(&quot;d&quot;, calldata, resolved date) <=5

You'd need to suppress everything that didn't meet the criterion


Madawc Williams
East Anglia, Great Britain

 

[ddrake]

Just the hint that was needed. Thanks!!