Microsoft Dynamics CRM 2011 Reporting

Microsoft Dynamics CRM 2011 Reporting
eBook: $29.99
Formats: PDF, PacktLib, ePub and Mobi formats
save 15%!
Print + free eBook + free PacktLib access to the book: $79.98    Print cover: $49.99
save 6%!
Free Shipping!
UK, US, Europe and selected countries in Asia.
Also available on:
Table of Contents
Sample Chapters
  • Create reports with SQL Reporting Services for CRM
  • Empower your reports with the different Report Wizards and dashboards
  • Troubleshoot and optimize your reports for better performance

Book Details

Language : English
Paperback : 308 pages [ 235mm x 191mm ]
Release Date : June 2013
ISBN : 1849682305
ISBN 13 : 9781849682305
Author(s) : Damian Sinay
Topics and Technologies : All Books, Enterprise Products and Platforms, Microsoft Dynamics, Enterprise, Microsoft

Table of Contents

Chapter 1: Introduction to Reporting in Microsoft Dynamics CRM
Chapter 2: Database Basics
Chapter 3: Creating Your First Report in CRM
Chapter 4: SQL Server Report Builder
Chapter 5: Creating Contextual Reports
Chapter 6: Creating Inline Reports
Chapter 7: Using Reports and Charts in Dashboard
Chapter 8: Advance Custom Reporting and Automation
Chapter 9: Failure Recovery and Best Practices
Chapter 10: Mobile Client
Appendix: Expression Snippets
  • Chapter 1: Introduction to Reporting in Microsoft Dynamics CRM
    • CRM report types
    • CRM report settings
      • Categories
      • Related Record Types
      • Display in
      • Languages
    • SQL reporting services versions
      • SQL Server databases
      • Windows Service
      • Report Manager website
      • Report Server Web service
    • Installation and configuration of Reporting Services Extensions
    • Installation and configuration of Report Authoring Extension (Visual Studio development)
    • Summary
    • Chapter 2: Database Basics
      • ERD basics
        • Relationship types
          • One-to-many relationships (1:N)
          • Many-to-one relationships (N:1)
          • Many-to-many relationships (N:N)
      • SQL overview
        • Select
        • Update
        • Delete
        • Insert
        • WHERE
        • ORDER BY
        • group by
        • join
      • SQL advanced
        • CREATE TABLE
        • DROP TABLE
        • Stored procedures
        • Cursors
        • Transactions
      • FetchXML overview
        • Select fields
        • Filters and conditions
        • Order by
        • Group by
        • Linking to other entities
          • Inner join
          • Outer join
      • Summary
        • Chapter 4: SQL Server Report Builder
          • Report Builder overview
          • Datasets
          • Query Designer
          • Creating a new report
            • Table or Matrix Wizard
            • Adding a logo to our report
          • Advanced reports with Report Builder
            • Map Wizard
            • Map visualization types
            • Testing the Map report
          • The Report Builder's limitations
          • Summary
          • Chapter 5: Creating Contextual Reports
            • Using Visual Studio
              • Toolbox
              • Expressions
              • Prefilters
            • Report parameters in detail
              • CRM_FilterText
              • CRM_FormatDate
              • CRM_FormatTime
              • CRM_FullName
              • CRM_FilteredAccount
              • CRM_URL
              • CRM_CalendarType
            • Data sources
              • Embedded data sources
              • Shared data sources
            • Data sets
            • Groups on data sets
              • Adding columns to the report
              • Hiding and showing columns
            • Charts
            • Drill-down and collapsible controls
            • Summary
            • Chapter 6: Creating Inline Reports
              • Embedding reports on an entity form
                • Creating a custom solution
                • Creating the HTML web resource
                • Implementing the report control
                • Developer Toolkit
              • Summary
                  • Chapter 9: Failure Recovery and Best Practices
                    • Common failures in SSR authentication
                    • Tracing
                      • Enabling CRM Trace
                      • Using SQL Trace
                    • Report development best practices
                    • Report deployment best practices
                      • Improving the performance of reports
                      • Creating report caching
                      • Creating report snapshots
                    • Summary
                    • Chapter 10: Mobile Client
                      • New features for mobile clients
                        • The sales process
                        • The autosave feature
                        • SQL Server 2012 with SP1
                        • Microsoft Surface
                      • The mobile client's considerations
                        • Authentication considerations
                        • Custom reports development considerations
                      • Summary
                      • Appendix: Expression Snippets
                        • Basic expressions
                          • Constants
                          • Variables
                        • Advanced expressions with VBScript code
                          • References
                          • Working with control events
                            • Actions
                            • Visibility
                            • Interactive Sorting
                        • Summary

                        Damian Sinay

                        Damian Sinay has over 15 years experience in the software development and IT industry. He started working with the .NET framework when its first Version 1.0 was in the beta stage. In 2002, he won first prize in the "Building solutions based on XML Web Services" contest, which spanned across Latin America, by Microsoft. In 2006, he wrote his first book in his native language (Spanish) on web services with C# development. He started working with CRM solutions prior to the first release of Microsoft Dynamics CRM's initial version. Since then, he has exclusively been developing and implementing solutions for Dynamics CRM and SharePoint. He is certified in Versions 3.0, 4.0, and 2011 including development, installation, configuration, and implementation of Dynamics CRM. He has around 18 Microsoft certifications (MCP) in SQL, C#, ASP.NET, TFS, Project, CRM, and SharePoint 2007 and 2010. Among many other things, he has co-authored the Dynamics CRM unleashed books for Versions 4.0 and 2011. He held the Microsoft Most Valuable Professional (MVP) award in Dynamics CRM in 2012 and serves as the CEO of Remoting Coders, a Microsoft Partner company that is turning 10 years old in 2013, providing solutions using Microsoft products and technologies. You can contact Damian at, follow him on Twitter at @damiansinay, and can also read the blog at
                        Sorry, we don't have any reviews for this title yet.

                        Code Downloads

                        Download the code and support files for this book.

                        Submit Errata

                        Please let us know if you have found any errors not listed on this list by completing our errata submission form. Our editors will check them and add them to this list. Thank you.

                        Sample chapters

                        You can view our sample chapters and prefaces of this title on PacktLib or download sample chapters in PDF format.

                        Frequently bought together

                        Microsoft Dynamics CRM 2011 Reporting +    Microsoft SQL Server 2008 R2 Master Data Services =
                        50% Off
                        the second eBook
                        Price for both: $43.05

                        Buy both these recommended eBooks together and get 50% off the cheapest eBook.

                        What you will learn from this book

                        • 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

                        In Detail

                        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.


                        The book is a focused and step-by-step tutorial on Microsoft Dynamics CRM Reporting capabilities. It will enable Dynamics developers to create and manage reports, know what tools to use, how to use them, and where to find the data based on how it’s being entered into the system with Dynamics CRM.

                        Who this book is for

                        This book is great for users and developers new to the Dynamics CRM Reports and SQL Server Reporting services, and who are looking to get a good grounding in how to use the reporting capabilities of Dynamics CRM 2011. It’s assumed that you will have some experience in HTML and JavaScript already to build the advanced reports, but no previous programming experience is required to build and learn how to create some basic to intermediate reports, which will be used during the exercises within this book.

                        Code Download and Errata
                        Packt Anytime, Anywhere
                        Register Books
                        Print Upgrades
                        eBook Downloads
                        Video Support
                        Contact Us
                        Awards Voting Nominations Previous Winners
                        Judges Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software
                        Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software