I'm trying to view CRM Customer data from the SQL database in SharePoint so that I can use it in surveys etc.
I followed these instructions (amongst others) http://crmconsultancy.wordpress.com/2011/12/15/integrating-dynamics-crm-data-into-sharepoint-2010/ and am having no joy. I've got the list page to show up but there is no data showing.
In SharePoint Designer when creating the Read List and Read Views I get the following error.
"This operation type can modify data in the data source. The data source element statecode is not nullable in the data source. Mark this data source element as a field in the operation."
I've no idea what this means. If anyone could help?