Dynamics CRM Custom FetchXML Reporting with Multiple Datasets using Pre-Filtering

I was recently assisting a CRM Online customer with troubleshooting a custom report they built. The report was running on the Opportunity as the main entity and also had 5 related datasets that were bringing in some specific connections related to that Opportunity. They were facing three big hurdles: 1. They wanted to use pre-filtering…


Microsoft Dynamics CRM Updates: Release Dates, Build Numbers, and Collateral

Note: The Updates documented in this blog for: Microsoft Dynamics CRM 2016 Microsoft Dynamics CRM 2015 Microsoft Dynamics CRM 2013 Microsoft Dynamics CRM 2011 update the Dynamics CRM components¬†described in this Microsoft Knowledge base article: Microsoft Dynamics CRM Installations, Updates and Documentation Notes: New naming conventions for Microsoft Dynamics CRM updates explained HERE Microsoft Dynamics…


“CRM Anywhere” Video Overview

Important Note: The CRM Product Group has published a blog titled “Q2 2012 Service Update – New delivery schedule” which clarifies the release plans for upcoming Update Rollups and Quarterly Service Updates in calendar year 2012.  Also, Reuben has since marked this video as private as the release schedule and scope have changed. In this…


Dynamics CRM & SQL 2012 Compatibility

Microsoft SQL 2012 RTM’d yesterday (link) and you’re probably wondering: “Can I upgrade my SQL Server instance to SQL 2012 if it hosts CRM databases?” and the answer is YES!  For CRM 2011 make sure you’ve installed update rollup 6 and for CRM 4.0 you should install update rollup 21 before upgrading.  After the upgrading…


CRM 2011 Error “Scheduling reports on behalf of other users is prohibitted” when scheduling reports

Recently I worked with a customer that encountered the error message “Scheduling reports on behalf of other users is prohibitted” when they tried to schedule reports in CRM 2011. After some troubleshooting we found the error was happening because the account running their CRMAppPool was also a CRM User.  It is a against best practices…


ReportingAccountMemberOfSecurityGroupValidator Error When Installing CRM 2011 Reporting Extensions

I recenty worked through an issue where a customer was receiving the following error when attempting to install the CRM 2011 Reporting Extensions: Check ReportingAccountMemberOfSecurityGroupValidator : Failure: A Microsoft Dynamics CRM Server component is using the same account as the instance of SQL Server Reporting Services. This error can occur for a variety of reasons. …


Dynamics CRM upgrade–SSRS issues

I recently completed a CRM 3.0 to 4.0 upgrade for a customer and ran into a couple SQL Server Reporting Services issues during the upgrade.  The SSRS errors took longer to fix than anything we ran into for CRM specifically. The first error came when attempting to point the SSRS server to the new databases…