03-21-2013 07:02 AM
I want to do a lookup/report that shows a particular record creator/manager within a certain time frame. For example, I would like to run a report that shows all activity by John Doe, the record manager, from January 1, 2013 to present. Thanks for any help on this one.
03-21-2013 08:03 AM
The process would be to first do a look up of the records that you want included in the report, Then run the notes/History report for this "current Lookup" Within the report, you will see three tabs, specify the date range and and user on the notes and the history tabs.
While the above solution will work in ACT, beyond that if you wanted a report that prompted you or allowed you to select variables, you would need to consider a 3rd party reporting tool like Crystal Reports or StoneField Queries.