Microsoft Dynamics CRM 2011 Reporting – Book Review

Packt Publishing has recently asked me to review the “Microsoft Dynamics CRM 2011 Reporting” book. I have just finished reviewing it and I found the book to be an excellent source for understanding reporting in Microsoft Dynamics CRM. It covers both the core reporting capabilities as well as the advanced dynamics CRM reporting features.

The book provides clear and valuable information about the basics of reporting, SQL Server, Dynamics CRM Entity Relationships and Database Basics. The book then delves into the Microsoft Dynamics CRM reporting capabilities starting with the simple Dynamics CRM report wizard to create Dynamics CRM reports and then focusing on the more advanced features. It introduces the SQL Report Builder and creating contextual and inline Dynamics CRM reports. It then briefly covers the use of reports and charts in Dynamics CRM dashboards. Finally the book discusses custom reporting and automation and the mobile client.

Overall the book is easy to read and has simple approach to explain complex reporting features in Dynamics CRM. I strongly recommend this book for Dynamics CRM reporting developers and other CRM consultants who want to understand more about the types of reports and capabilities Microsoft Dynamics CRM has.

Microsoft Dynamics CRM 2013 and Dynamics CRM Online Fall 13 (ORION) announced today

Microsoft Corp. today announced that it plans to make the next version of Microsoft Dynamics CRM available in the fall of 2013.

Available both online as Microsoft Dynamics CRM Online Fall ’13 and on-premises as Microsoft Dynamics CRM 2013, this major release will deliver more personal experiences to sales, marketing and customer care professionals.

Full details here:

The new release gives people the ability to access their information on a variety of devices;* introduces a new user experience that is fast and fluid, enabling people to access information that is relevant to their jobs; and delivers richer contextual information that helps people have deeper insights into customers and their needs. Microsoft Dynamics CRM also offers enhanced social collaboration capabilities, so users can connect with the right people, and the right resources, at the right time.

There will also be:

• A connection to MarketingPilot,

• Introducing new mobile client applications on iPad and Windows 8 tablets

• Providing capabilities for people to collaborate with each other and share customer knowledge through Yammer right within the CRM solution

• Connecting Lync and Skype seamlessly

• Netbreeze. As part of the Microsoft’s work to bring the capabilities of Netbreeze, its recently acquired social monitoring and analytics service, to customers, the company will also be offering a limited beta of the service available in fall 2013



Microsoft Dynamics CRM 2011 and Online Error Codes – full list of API Web Service Error Codes from SDK

Microsoft Dynamics CRM Error Code list of Web Service and API Error Codes. The following is copied from MSDN online and Microsoft Dynamics CRM SDK.

This topic lists the error codes you may encounter when debugging your code. You can find helper code for using error codes in the Microsoft Dynamics SDK download package in the folder SDK\SampleCode\CS\HelperCode\ErrorCodes.cs. In the same folder you will also find CrmErrors.xlsx, which is provided for an easy way to look up error information. For more information, see Handle Exceptions in Your Code.

The following table lists the error codes used in Microsoft Dynamics CRM. I have coped it into a post so that it is easy for me and hopefully for everyone else to pick these errors up. Please note that errors usually start with Ox which refers to the code being in hexadecimal. Error codes below do not have the Ox prefix. You need to remove it from your error code before you search.

Continue reading “Microsoft Dynamics CRM 2011 and Online Error Codes – full list of API Web Service Error Codes from SDK”