MS Dynamics CRM vs Salesforce Sign up for a free CRM course! Learn more about CRM's features Retrieving data and metadata for reports In Microsoft Dynamics CRM can be done using SQL views. In Dynamics CRM, users can run queries on SQL views that are automatically created. As the image below shows, names within the …
Posts Tagged ‘Microsoft CRM and SQL Queries’
Syntax when using CTEs in an SSRS Report Dataset for Microsoft Dynamics CRM
CTE’s (Common Table Equivalent) are very useful when writing complex SQL queries. I recently used one in a dataset in a report. This was a secondary dataset that I was appending to an existing report which was already in CRM and worked correctly. Designing and testing the reports in Visual Studio worked as well. Only …
Syntax when using CTEs in an SSRS Report Dataset for Microsoft Dynamics CRM Read More »