I have a field in my ssrs dynamics crm report using sql which runs against a case, I need it to display the URL for the sharepoint location for documents related to that case.
Has anyone got any experience and can help on using the correct tables in order to create a expressions which displays the correct URL related for that case for its document location.
sharepointdocumentlocation is the entity which will store document URL in relativeurl attribute. You have to look for case guid in regardingobjectid
Check absoluteurl for fully qualified navigation link. These are totally up to your project for values.
Edit: From this forum & thread, Its clear that CRM does not have OOB way to store this. Need to write custom code to update a field on record or custom code/query to retrieve absolute URL.
For sharepoint site details, query the sharepointsite entity for absoluteurl or relativeurl.
