Microsoft Dynamics CRM 2011 Reporting

Everything you need to know to work with reports in Dynamics CRM 2011
Preview in Mapt

Microsoft Dynamics CRM 2011 Reporting

Damian Sinay

Everything you need to know to work with reports in Dynamics CRM 2011
Mapt Subscription
FREE
$29.99/m after trial
eBook
$21.00
RRP $29.99
Save 29%
Print + eBook
$49.99
RRP $49.99
What do I get with a Mapt Pro subscription?
  • Unlimited access to all Packt’s 5,000+ eBooks and Videos
  • Early Access content, Progress Tracking, and Assessments
  • 1 Free eBook or Video to download and keep every month after trial
What do I get with an eBook?
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with Print & eBook?
  • Get a paperback copy of the book delivered to you
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with a Video?
  • Download this Video course in MP4 format
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
$0.00
$21.00
$49.99
$29.99p/m after trial
RRP $29.99
RRP $49.99
Subscription
eBook
Print + eBook
Start 30 Day Trial

Frequently bought together


Microsoft Dynamics CRM 2011 Reporting Book Cover
Microsoft Dynamics CRM 2011 Reporting
$ 29.99
$ 21.00
Microsoft Dynamics CRM 2011: Dashboards Cookbook Book Cover
Microsoft Dynamics CRM 2011: Dashboards Cookbook
$ 23.99
$ 16.80
Buy 2 for $34.30
Save $19.68
Add to Cart
Subscribe and access every Packt eBook & Video.
 
  • 5,000+ eBooks & Videos
  • 50+ New titles a month
  • 1 Free eBook/Video to keep every month
Start Free Trial
 

Book Details

ISBN 139781849682305
Paperback308 pages

Book Description

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

Chapter 1: Introduction to Reporting in Microsoft Dynamics CRM
CRM report types
CRM report settings
SQL reporting services versions
Installation and configuration of Reporting Services Extensions
Installation and configuration of Report Authoring Extension (Visual Studio development)
Summary
Chapter 2: Database Basics
ERD basics
SQL overview
SQL advanced
FetchXML overview
Summary
Chapter 3: Creating Your First Report in CRM
Using Microsoft Dynamics CRM 2011 Report Wizard
Using Visual Studio
Publishing the report
Summary
Chapter 4: SQL Server Report Builder
Report Builder overview
Datasets
Query Designer
Creating a new report
Advanced reports with Report Builder
The Report Builder's limitations
Summary
Chapter 5: Creating Contextual Reports
Using Visual Studio
Report parameters in detail
Data sources
Data sets
Groups on data sets
Charts
Drill-down and collapsible controls
Summary
Chapter 6: Creating Inline Reports
Embedding reports on an entity form
Summary
Chapter 7: Using Reports and Charts in Dashboard
Showing report on a dashboard
Basic charts
Charts editor
Summary
Chapter 8: Advance Custom Reporting and Automation
The ASP.NET report
Silverlight reports
Basic report automation
Advanced report automation (programmatically)
Summary
Chapter 9: Failure Recovery and Best Practices
Common failures in SSR authentication
Tracing
Report development best practices
Report deployment best practices
Summary
Chapter 10: Mobile Client
New features for mobile clients
The mobile client's considerations
Summary

What You Will Learn

  • Understand the different report types we can create in Microsoft Dynamics CRM
  • Learn basic database concepts like ERD and SQL and Fetch XML languages to create queries on our reports
  • Create basic reports with the wizard and Visual Studio
  • Build advanced reports with the SQL Report Builder
  • Present reports in charts, dashboards and forms
  • Integrate reports on CRM entity forms and extending the form's control capabilities
  • Incorporate reports in CRM dashboards and understand chart basics to display important information
  • Bind CRM data by using early or late binding and SQL reporting services report execution
  • Follow the best practices and troubleshooting of different authentication issues

Authors

Table of Contents

Chapter 1: Introduction to Reporting in Microsoft Dynamics CRM
CRM report types
CRM report settings
SQL reporting services versions
Installation and configuration of Reporting Services Extensions
Installation and configuration of Report Authoring Extension (Visual Studio development)
Summary
Chapter 2: Database Basics
ERD basics
SQL overview
SQL advanced
FetchXML overview
Summary
Chapter 3: Creating Your First Report in CRM
Using Microsoft Dynamics CRM 2011 Report Wizard
Using Visual Studio
Publishing the report
Summary
Chapter 4: SQL Server Report Builder
Report Builder overview
Datasets
Query Designer
Creating a new report
Advanced reports with Report Builder
The Report Builder's limitations
Summary
Chapter 5: Creating Contextual Reports
Using Visual Studio
Report parameters in detail
Data sources
Data sets
Groups on data sets
Charts
Drill-down and collapsible controls
Summary
Chapter 6: Creating Inline Reports
Embedding reports on an entity form
Summary
Chapter 7: Using Reports and Charts in Dashboard
Showing report on a dashboard
Basic charts
Charts editor
Summary
Chapter 8: Advance Custom Reporting and Automation
The ASP.NET report
Silverlight reports
Basic report automation
Advanced report automation (programmatically)
Summary
Chapter 9: Failure Recovery and Best Practices
Common failures in SSR authentication
Tracing
Report development best practices
Report deployment best practices
Summary
Chapter 10: Mobile Client
New features for mobile clients
The mobile client's considerations
Summary

Book Details

ISBN 139781849682305
Paperback308 pages
Read More

Read More Reviews

Recommended for You

Microsoft Dynamics CRM 2011 Scripting Cookbook Book Cover
Microsoft Dynamics CRM 2011 Scripting Cookbook
$ 29.99
$ 21.00
Microsoft Dynamics CRM 2011 Customization & Configuration (MB2-866) Certification Guide Book Cover
Microsoft Dynamics CRM 2011 Customization & Configuration (MB2-866) Certification Guide
$ 35.99
$ 25.20
Microsoft Dynamics CRM 2011: Dashboards Cookbook Book Cover
Microsoft Dynamics CRM 2011: Dashboards Cookbook
$ 23.99
$ 16.80
Microsoft Dynamics CRM 2011 Application Design Book Cover
Microsoft Dynamics CRM 2011 Application Design
$ 29.99
$ 21.00
Salesforce CRM: The Definitive Admin Handbook Book Cover
Salesforce CRM: The Definitive Admin Handbook
$ 35.99
$ 25.20
Salesforce CRM: The Definitive Admin Handbook - Second Edition Book Cover
Salesforce CRM: The Definitive Admin Handbook - Second Edition
$ 32.99
$ 23.10