You need to sign in to do that
Don't have an account?
Report on case
Hi All,
I need a report based on Case. I need to calculate the time duration when the case is in "R&D" and "in Progress" status.
However this report should show the time duration according to the representative.
e.g. there is a case 1
1. User1 change the status from NEW to IN PROGRESS. say at 9am
2. User 2 change the satus from IN PROGRESS to HOLD Say at 10am
3. User3 change the status from HOLD to R&D say at 12 pm
4. USer4 change the status from R&D to closed say at 15 pm
Hence i need report as
User 1 :: Working hours 1(10am-9am) IN PROGRESS
User2 :: Working hours 3 (15pm -12pm) R&D
Any help and suggestion is highly appreciable.
Thanks,
Mayank
There could be "N" users changing the status.. I would recommend creating a related object to case and write trigger on case everytime the status changes and insert a record into related object as per your needs of reporting.