Get Ready for the Next Release of Microsoft Dynamics CRM
Problems configuring the CRM Outlook client? Use the wizard!
Customer Center for Microsoft Dynamics CRM 2013
Customer Center for Microsoft Dynamics CRM 2011
Technical Support FAQ: Online | On-Premise
Developer Center and SDK
Is there any way to report of this Value as it is available when you loose an opportunity but I can not find any way to report these values?
It would seem logical that you could get a 'Lost Opportunity' report showing details of the opportunity along with why it was lost, which competitor won it and the description as to why they won it?
Thank you in advance for you assistance.
You could try to construct a report yourself
Then you need to retrieve the correct fields from an opportunity and show them on the report.
Have your tried that? Is that an option?
Sven VanoirbeekSenior consultant - Dynamics CRM
The problem I have is that the 'competitor' field from the opportunity close screen does not appear to be on any of the opportunity tables?
I can report of every other field, including the 'Actual Close Date' and the description that is on this final close screen but not the 'competitor'?
Does anyone know where this field is stored?
Could I please ask if anyone else has any thoughts on this issue?
The competitor field is stored on an activity called Opportunity Close. You cannot access the activity from advanced find like you can with other activities, as it is treated as one of the "special cases".
My other thought is the native report writer can be used to get at this activity. You could create a report using the Opportunity and Opportunit Close entities, and generate a list of lost opportunties and their competitors.
Other Microsoft Sites
I'm a Customer
I'm a Partner
Follow Microsoft Dynamics