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 SQL views are easy to identify. A Microsoft tip sheet notes that SQL-based reports in Dynamics CRM use the filtered views provided for each entity to retrieve data for the reports.
To obtain the query, users can download the SQL Server Management Studio (SSMS) online.
Apart from being automatically created, Filtered Views offer the benefit of being updated for custom entities, having security embedded in the view, and being supported after patches, service releases and upgrades.
Linz Tan, Web Marketing Assistant, WebSan Solutions Inc. a 2014 Ontario Business Achievement Award Winner for Service Excellence.