Hi ,

I have to bulid a cross tab object in an existing crystal report. All I need to show in cross tab is the orders,status date, status , date difference in minutes. The Order can go thru different status(a,b,c,d) until status becomes Ready. I need to calculate Time difference in minutes from when the status changed from (a,b,c,d) to Ready. For Each time the status changed the time is captured into the field status date.   I have created the two running totals to capture the time when the status reached Ready and also the time when the status is in any of these values(a,b,c,d) and then created a formula to do the date diff to get the time in mins from these two running totals. But I need a cross tab where in I can display the data as below


                  status(a,b,c,d)      status(Ready)    delay
order 1       datetime             datetime               20mins
order 2       datetime             datetime               2mins
order 3       datetime             datetime               -5mins
order 4       datetime             datetime               40mins


Please Advise

Thanks!
Abhi

Hi Dell

Thanks for your reply .. If I want to implement the same logic with the same layout of the report can I accomplish this in cross tab

Thanks!
Abhi

Okay , Thanks Dell for your Time