You need to sign in to do that
Don't have an account?
Reporting on WHEN an Activity was marked Completed
I was trying to build a weekly report of of completed activities. I want to know WHEN the status was changed to Completed. When I went in to create a new report, History was no whereto be found. So I thought History Tracking was not turned on on the Activity object, but when I went to check, I found that it was not an option. No worries, I thought I would just go in and create a new report type to solve the problem, but can't seem to do it there either.
Any advice here? Again, I'm not looking for a simple list of completed activities, I'm looking for the date that represetns WHEN the status was changed to Completed. I think on a custom object, I would just turn history on and report against those records, but having problems doing that on the Activity object.
TB
Hi,
In order to find when a task was closed you can capture the same info in a custom field using a trigger written on task object.
Then you can create a report which captures alll those fields which holds a not null value for the field which holds the task closure date.
Did this answer your question? If not, let me know what didn't work, or if so, please mark it solved.
All Answers
Hi,
In order to find when a task was closed you can capture the same info in a custom field using a trigger written on task object.
Then you can create a report which captures alll those fields which holds a not null value for the field which holds the task closure date.
Did this answer your question? If not, let me know what didn't work, or if so, please mark it solved.
I was afraid that was the answer! We have Group Edition, so no-go on the trigger. I'm going to over-communicate an internal business rule simply to update the Date field manually when they mark it complete, and that field will be used in the report I am writing.
Thanks though!
TB