I am using Crystal Reports 8.5 and am trying to determine when 3 or more tickets occurred within 60 days for the same customer.
My ticket information is on separate rows. I know how to tell if there are 3 or more tickets between given dates by using a simple formula such as:
Formula 1
if {table.ticket_time} in currentdate - 61 to currentdate-1
and not isnull ({table.ticket}) then 1
Formula2
sum ({@CurrentDate-1_Formula1}, {table.customer})
Then I can do a formula that counts all tickets from Formula 2 if the result is >=3.
I have also tried using previous and next functions to get the data all on one row and then adding the dates to determine if there were 3 tickets within 60 days. If I do this I can't figure out a way to identify the 1st and 3rd tickets that meet the criteria so I can display these tickets and suppress all tickets that do not meet the criteria of 3 or more within 60 days.
Thanks for any suggestions you can provide.
My ticket information is on separate rows. I know how to tell if there are 3 or more tickets between given dates by using a simple formula such as:
Formula 1
if {table.ticket_time} in currentdate - 61 to currentdate-1
and not isnull ({table.ticket}) then 1
Formula2
sum ({@CurrentDate-1_Formula1}, {table.customer})
Then I can do a formula that counts all tickets from Formula 2 if the result is >=3.
I have also tried using previous and next functions to get the data all on one row and then adding the dates to determine if there were 3 tickets within 60 days. If I do this I can't figure out a way to identify the 1st and 3rd tickets that meet the criteria so I can display these tickets and suppress all tickets that do not meet the criteria of 3 or more within 60 days.
Thanks for any suggestions you can provide.