11/25/2024 7:38:51 AM
|
| |
| slxdeveloper.com Community Forums |
|
| |
|
|
The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
Forum to discuss reports for SalesLogix including Crystal, SQL Reports, etc. View the code of conduct for posting guidelines.
|
|
|
|
Activities report
Posted: 05 Dec 06 8:35 PM
|
fiogf49gjkf0d Trying to write a report to show turnaround of sales reps on activities. I see in the HOSTORY table there is are two fields RESULT and RESULTCODE.
The RESULTS field seems to contain either "update" or "complete" as its value and the RESULTCODE has DON, COM, SLD, DLD, CLB.
Does anyone know what these codes represent??
Object of the report is to show when activity was raised and who was assigned Leader of it. Any updates to the notes (can't track as far as I can see), and when it was completed.
Any help would be much appreciated.
Thanks in advance. |
|
|
|
Re: Activities report
Posted: 05 Dec 06 9:14 PM
|
fiogf49gjkf0d Those are defined in the History Resuls picklist. Each picklist item has two parts. The text and a code. The codes you mention all correspond to text items in that picklist. Open the picklist and take a look.
-Ryan |
|
|
|
You can
subscribe to receive a daily forum digest in your
user profile. View the site code
of conduct for posting guidelines.
 Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
|
|
|
|
|
|
|
|