Reporting and Analysis

Entity Views and Advanced Find

We explained how to set up and configure entity views in "Forms and Views," but we want to emphasize that you can use entity views in conjunction with the Advanced Find feature as an entry-level reporting and analysis tool. Entity views and the Advanced Find feature offer the following reporting benefits:

1. Users of all skill levels can set up and configure views by using the Advanced Find feature, but Advanced Find also offers powerful query features such as Group AND and Group OR that more sophisticated report writers will want.

2. Users can save any views that they create using the Advanced Find feature so they can quickly run that report later.

3. By default, only the user who creates an Advanced Find view can access it. However, Microsoft CRM allows you to share Advanced Find views with other users or with a team. Therefore, you can explicitly control access to a view so that only a select group of users has access.

4. Entity system views (but not saved Advanced Find views) can be imported or exported along with the other system customizations.

5. Users can sort the records in their views in ascending or descending order by clicking the column headers.

6. Users can export the records in their views to Excel, and they can create dynamic worksheets that link to the Microsoft CRM database.