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 ‘SQL reporting’
New Reporting Expressions in SQL Server 2008 R2 / Microsoft CRM - Tutorial
SSRS 2008 R2 (SQL Server Reporting Services) includes some new expressions which allow us to bring into one table values from another dataset based on the table’s current dataset fields. In other words, Lookup <fieldname> from <dataset2> where <fieldname><dataset1> = <fieldname><dataset2>. The LookUp function is based on a 1 to 1 relationship, bringing in one …
New Reporting Expressions in SQL Server 2008 R2 / Microsoft CRM - Tutorial Read More »