jericksonsun1031
IS-IT--Management
- Oct 17, 2007
- 1
Hi,
I'm trying to come up with a custom report but I can't quite seem to get it right. What I want it to do come up with a report that will list a name of contacts sorted by sales rep by date. SOmething like this:
Day1 TotalContactsForDay1
Salesrep1 TotalContactsRep1
Contact1
Contact2
Contact3
Salesrep2 TotalContactsRep2
Contact1
Contact2
Contact3
Day2 TotalContactsForDay2
Salesrep1 TotalContactsRep1
Contact1
Contact2
and so on. Problem I'm running into is that the date is not sorting, the rep is not grouping, it's creating a new line for the same rep for every contact. Anyone know how to create something like this? I'm pulling my hair out! haha.
I'm trying to come up with a custom report but I can't quite seem to get it right. What I want it to do come up with a report that will list a name of contacts sorted by sales rep by date. SOmething like this:
Day1 TotalContactsForDay1
Salesrep1 TotalContactsRep1
Contact1
Contact2
Contact3
Salesrep2 TotalContactsRep2
Contact1
Contact2
Contact3
Day2 TotalContactsForDay2
Salesrep1 TotalContactsRep1
Contact1
Contact2
and so on. Problem I'm running into is that the date is not sorting, the rep is not grouping, it's creating a new line for the same rep for every contact. Anyone know how to create something like this? I'm pulling my hair out! haha.