Book Image

Microsoft Dynamics CRM 2011 Reporting

By : Damian Hernan Sinay
Book Image

Microsoft Dynamics CRM 2011 Reporting

By: Damian Hernan Sinay

Overview of this book

All of the data entered into a CRM means nothing if it is unable to report the important information to our managers and executives in such a way that they can easily and quickly get the results they need. A better reporting system would enable them to make the necessary improvements to the processes that any business needs in a dynamic business world.For users and developers wishing to take advantage of using the report capabilities of Dynamics CRM, this is the book for you. Microsoft Dynamics CRM 2011 Reporting is a practical and excellent reference guide that provides you with a number of different options you can use to create and empower the Reporting capabilities of Dynamics CRM. This will give you a good grounding in using the reports in your Dynamics CRM 2011 implementations. This book looks at all the different options we can use to create reports in Dynamics CRM 2011, starting with SQL Reporting Services and custom reports, created in either CRM Report Wizard, SQL Report Builder, or Visual Studio. It will also show other options we can use such as dashboards, charts, and different ways to optimize and automate reports.We will also learn how to build our own reports either using the different wizards for basic reports or using Visual Studio for more complex reports. We will explore the options mobile CRM users have who want to run and see reports on these mobile devices.
Table of Contents (18 chapters)
Microsoft Dynamics CRM 2011 Reporting
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

CRM report settings


Reports in Dynamics CRM have the following settings or categories that you can access by clicking on the Edit button of each report, as shown in the following screenshot:

In the Report: Account Summary window you will see two tabs, General and Administration.

The Administration tab will show the name of the owner of the report, when the report was created or updated and who did it, and whether it is viewable to the user or the entire organization.

In the General tab, you will see the name of the report and the description. If it is a subreport, we will see the parent report displayed. Lastly, in the Categorization section, you can see the following settings:

  • Categories

  • Related Record Types

  • Display in

  • Languages

We will study each of these settings in detail.

Categories

By default, there are four categories created out of the box in every CRM organization:

  • Administrative Reports

  • Marketing Reports

  • Sales Reports

  • Service Reports

You can change, add, or remove these categories by navigating to Settings | Administration | System Settings | Reporting as shown in the following screenshot:

These report categories are used so that you can filter reports by each category when the predefined views are available in the main Reports interface, as shown in the following screenshot:

Notice that if you add a new category, you will also have to create the view as it won't be created automatically.

Related Record Types

The Related Record Types option allows you to select what entities you want the report to be displayed under.

The reports will be listed under the Run Report button that is on the Ribbon. There are two locations where the report will be listed on the entities you selected: the home page grid and the form.

The home page grid is where you see all the records of an entity (depending on the view you selected) as shown in the following screenshot:

Almost every entity in Dynamics CRM has a Run Report button. As you can see, there are some reports that can run on the selected records and there are others that only run on all records. We will see how to configure this in detail when we go deeper into report development with Visual Studio in Chapter 5, Creating Contextual Reports.

The form is the second place where the Run Report button is located and it is visible on the form record that you will see when you open a record; the report will only affect that record.

Display in

As we saw in the Related Record Types option, we can decide here where we want to show our report. The options are:

  • Forms for related record types

  • Lists for related record types

  • The Reports area

The first option will make the report available on the Run Report button, which is on the form ribbon of an entity record as we have seen earlier.

The lists for the Related Record Types option appears on the home page grid ribbon button.

The Reports area refers to the main reporting interface that is in the Workplace.

Languages

This last option of the Categorization section allows us to specify the language of the report. We have the option of selecting all the languages on the list if you want your single report to be displayed in any of these languages. This is helpful if we have the different language packs installed on the CRM Server and the organization has people from different countries who understand different languages. By default all the reports are based on the local language.

Note

This option might not be visible on your installation if you don't have any other language installed on the system.