Posts Tagged ‘Microsoft CRM and SQL Queries’

WebSan Solutions Inc. 's Logo Retrieving Data in Microsoft Dynamics CRM

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 …

Retrieving Data in Microsoft Dynamics CRM Read More »

Hitachi Solutions America, Ltd.'s Logo 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 »

 

Show Buttons
Hide Buttons