Build XRMServices Request for Microsoft Dynamics CRM

Use the CRM 2011 OData Query Designer tool. In addition, here’s some examples: Get Quote details for a specific quote /XRMServices/2011/OrganizationData.svc/QuoteDetailSet?$filter=QuoteId/Id eq guid'<RECORD_GUID>’ Get specific property details (e.g. ExtendedAmount and Quantity) for a specific entity (e.g. Quote Detail) /XRMServices/2011/OrganizationData.svc/QuoteDetailSet?$select=ExtendedAmount,Quantity&$filter=QuoteId/Id eq guid'<RECORD_GUID>’ Filter on custom entities and how to use multiple …

How to Specify a Filename For Your Exported Reports in Microsoft Dynamics CRM 2011

As you probably already know, there’s no built-in way to specify the filename of a report you want to export to PDF, Excel, Word, etc. Then a colleague pointed me to this article.  First off, the code for the below solution can be downloaded here. This one took a while …

MSSQL 2005 Dynamic PIVOT

Here’s a method of generating a dynamic pivot of a dataset. It first generates the columns as a string (“[ColumnHeader0],[ColumnHeader1],[ColumnHeader2], …” format), builds a dynamic SQL string and executes it using the PIVOT expression. From the code below, the @cols variable is generated by using the FOR XML PATH expression. …