How big is the CRM database?

As consultants, we often perform an analysis of CRM systems belonging to prospects or customers, perhaps because they have performance issues, they want to upgrade, or we need to understand more about their current implementations.

If the CRM is on-premises, it is useful to find out about which out-of-the-box CRM entities are used, custom entities if any, number of records, and size of tables. You can find out all about this easily through few clicks and without having to write any T-SQL.

Continue reading “How big is the CRM database?”

How to resolve “The column heading cannot be empty.” when importing CSV to Dynamics CRM

You are importing a CSV content to your Dynamics CRM instance, and receive the following error, “The column heading cannot be empty.”

Continue reading “How to resolve “The column heading cannot be empty.” when importing CSV to Dynamics CRM”

Display and Report User Business Units, Teams, and Security Roles

If you need to produce a report to display and audit users’ Business Units, Teams, and Security Roles of your Dynamics CRM, for example to ensure the correct users are assigned correctly before the go-live, then this report may be useful.

Continue reading “Display and Report User Business Units, Teams, and Security Roles”

Troubleshooting “The report cannot be displayed. (rsProcessingAborted)” Error Message in CRM

When you develop an SSRS report for CRM with Visual Studio Business Intelligence Studio and test the report working in Visual Studio, but not when uploaded to CRM, you will encounter the following error:

Reporting Error

The report cannot be displayed. (rsProcessingAborted)

Try Again | Close

Continue reading “Troubleshooting “The report cannot be displayed. (rsProcessingAborted)” Error Message in CRM”

Cross-browser JavaScript functions to Retrieve and Update CRM Records

There’re plenty of examples on the Internet of how to use JavaScript to retrieve and update records in CRM 2011 or CRM 2013. However, I find many of them are overly too complex and require inclusion of proprietary JavaScript libraries, some doing them asynchronously, and some don’t work with non-IE web browsers.

Continue reading “Cross-browser JavaScript functions to Retrieve and Update CRM Records”

Metro-style Icons for CRM 2013

CRM 2013 has gone metro-style and so should your icons for custom buttons and entities!

icons8 (http://www.icons8.com) has a large (1500+) metro-style icons perfect for this. They are free for personal and commercial, use, as long as you include an attribution and a link back to their site. Alternatively, you can purchase them at a very nominal fee of USD 149.

Continue reading “Metro-style Icons for CRM 2013”