thread767-1450985
In Crystal Reports XI:
I'm trying to get a list of accounts for which there has been no activity over the past 2 years - based upon a task start date.
Ideally, I need a list of these accounts/customers so we can have someone begin calling on them.
The specific data field is based upon a task being completed or not completed and the field name is called: tblTasks.StartDate.
So for the past 2 years, I want to know who does not have a task either completed or uncompleted : tblTasks.TasksCompletedIndicator (true or false)
Please help and let me know if you need more info.
Thanks in advance!
In Crystal Reports XI:
I'm trying to get a list of accounts for which there has been no activity over the past 2 years - based upon a task start date.
Ideally, I need a list of these accounts/customers so we can have someone begin calling on them.
The specific data field is based upon a task being completed or not completed and the field name is called: tblTasks.StartDate.
So for the past 2 years, I want to know who does not have a task either completed or uncompleted : tblTasks.TasksCompletedIndicator (true or false)
Please help and let me know if you need more info.
Thanks in advance!