I need a Website built where a salesperson can login and record their sales call data.
They need to be able to sign up which can be the usual details:
Company Name (Not Mandatory)
The salesperson's ID will be tied to their email address. (We will use this email ID later to pay Affiliate commissions)
The salesperson must make 50 calls per week or I need to be emailed to look at their call report info. This will be checked against a calendar.
So you must tabulate all the entries.
I need to run the following reports:
1. Number of all calls by Salesperson In Date Range
2. Total Number of calls in a City,State or Zip Code
3. Any prospect in street, city, state or zip code
4. Any prospect in a specialty
5. Number of Do Not Contacts
This is to be developed in [url removed, login to view] and MS SQL