Chapter at a Glance
✓ | Perform ad hoc queries by using Advanced Find. |
✓ | Organize and format Advanced Find results. |
✓ | Create a saved view. |
✓ | Use saved views to share your queries with other users. |
✓ | Build a complex query to search data. |
✓ | Use bulk edit and bulk assign to take action on query results. |
An important benefit of CRM systems is the central repository of customer data that builds as sales, marketing, and customer service teams track their interactions with customers. As this store of data grows, managers face the need to report on and analyze the data to understand trends and identify areas for improvement. Microsoft Dynamics CRM provides a variety of tools for extracting data and presenting it in a simple and easy-to-use format. This chapter focuses on the best tool for this task: Advanced Find. The Advanced Find tool lets you create your own queries through a simple interface. When end users are empowered to create reports and filter the results to return a specific data set, they rely less on IT resources to do their job. In addition, this flexibility will increase an organization’s IT resources to focus on more complex business requirements.
In this chapter, you will learn to harness the power of the Advanced Find tool by creating a query, saving it as a system view that can be shared with others, and updating multiple records in the results set.
Tip
Advanced Find respects the security settings of the end user. As a rule of thumb, you can assume that if a user can see the record elsewhere in the application, that user will be able to gain access to it within Advanced Find.
Troubleshooting
Graphics and operating system–related instructions in this book reflect the Windows Vista user interface. If your computer is running Windows XP and you experience trouble following the instructions as written, refer to the "Information for Readers Running Windows XP" section at the beginning of this book.
Important
The images used in this book reflect the default form and field names in Microsoft Dynamics CRM. Because the software offers extensive customization capabilities, it’s possible that some of the record types or fields have been relabeled in your Microsoft Dynamics CRM environment. If you cannot find the forms, fields, or security roles referenced in this chapter, contact your system administrator for assistance.
Important
You must know the location of your Microsoft Dynamics CRM Web site to work the exercises in this book. Check with your system administrator to verify the Web address if you don’t know it.
Business needs can change frequently over the course of a project and, as a result, reporting needs also change. Therefore, ad hoc reporting has become a standard feature within most business applications, because expecting end users to define all of their reporting needs before a system is implemented is unrealistic. The Advanced Find tool within Microsoft Dynamics CRM provides a flexible interface to query, view, analyze, and update data on an ongoing basis, so that predefined queries can be saved as the system is implemented and new queries can be created as the reporting needs of your business change. Examples of how Advanced Find is commonly leveraged by end users include:
Configuring a customized to-do list to follow up on open opportunities.
Determining leads that fall into a specific geographical region for distribution and assignment.
Finding all activities due on the current date for a specific customer service representative who has called in sick, so that the activities can be reassigned to a different representative.
Obtaining a list of contacts that have not been modified in more than two years, so that they can be considered for deactivation.
Advanced Find queries rely on an intuitive set of operators that you select when building a query. The data fields you select in your query determine the operators that will be available for filtering. The following table highlights the operators available for the different data fields.
Operators | ||
|---|---|---|
User (Owner) | Equals Current User | Contains |
Does Not Equal Current User | Does Not Contain | |
Equals | Begins With | |
Does Not Equal | Does Not Begin With | |
Contains Data | Ends With | |
Does Not Contain Data | Does Not End With | |
Text | Equals | Does Not Contain |
Does Not Equal | Begins With | |
Contains Data | Does Not Begin With | |
Does Not Contain Data | Ends With | |
Contains | Does Not End With | |
Numeric | Equals | Is Less Than |
Does Not Equal | Is Less Than Or Equal To | |
Is Greater Than | Contains Data | |
Is Greater Than Or Equal To | Does Not Contain Data | |
Date | On | This Year |
On Or After | Last X Hours | |
On Or Before | Next X Hours | |
Yesterday | Last X Days | |
Today | Next X Days | |
Tomorrow | Last X Weeks | |
Next 7 Days | Next X Weeks | |
Last 7 Days | Last X Months | |
Next Week | Next X Months | |
Last Week | Last X Years | |
This Week | Next X Years | |
Next Month | Any Time | |
Last Month | Older Than X Months | |
This Month | Contains Data | |
Next Year | Does Not Contain Data | |
Last Year | ||
For each query, you can specify as many search criteria as you need. You must designate the primary record type you want returned in the results, but you can also include data fields from related records in your query. For example, you might search for top sales opportunities that are assigned to sales representatives in a certain geographical region. Your search could include the data fields the sales team uses to rate opportunities as well as the sales region field for the user records to which opportunities are assigned.
In this exercise, you will create an Advanced Find query to view the opportunities that have a probability value greater than 50 for accounts in the city of Chicago.
Note
USE your own Microsoft Dynamics CRM installation in place of the Adventure Works Cycle site shown in this exercise.
BE SURE TO use the Windows Internet Explorer Web browser to navigate to your Microsoft Dynamics CRM Web site before beginning this exercise.
On the application menu toolbar, click the Advanced Find button.
The Advanced Find screen opens.
In the Look for list, select Opportunities.
This specifies the primary entity for which you will be executing the query.
In the Select field, choose Probability to set the search criteria for the opportunity’s Probability field.
A second list of operators is displayed to the right of the Select field.
In the Operator field, select Is Greater Than. Then, in the Enter Value field, enter 50.
In the second row of the Advanced Find query, in the Select field, scroll to the bottom of the list to the Related section and select Potential Customer (Account) to add a data field from the account record type to your search.
This allows you to filter on attributes of the account related to the opportunities.
In the Select field, choose Address 1: City.
In the Operator field, leave Equals selected, and in the Enter Value field, enter Chicago.
Click the Find button in the lower right corner of the screen.
The results of your search are displayed.
