Knowledgebase

Welcome

Welcome to my knowledgebase, which contains snippets of information that I find (mostly about Microsoft Dynamics 365/CRM) and then forget.

You are most welcome to browse and if any of the information helps you in your work with Microsoft Dynamics CRM then that is great.

Use the search box or the tag links to search for articles.

I’m an experienced Microsoft Dynamics 365/CRM Consultant and Microsoft Certified Trainer available for hire on an ad-hoc basis. Please contact me to see how I can help with your Microsoft Dynamics project. Find out more about me.

Recently updated articles

Service Accounts for SQL 2012


26 May 2014

SQL 2012 can use Managed Service Accounts and Virtual Local Accounts as described here: http://msdn.microsoft.com/en-us/library/ms143504%28SQL.110%29.aspx#New_A...

Installing CRM 2013 works with the default virtual local accounts created when installing SQL 2012. However, installing Reporting Extensions reports an error that a local account is used for Reporting Services and this must be changed to a domain account.

FetchXML Field Types in SSRS


15 May 2014

When creating reports that use FetchXML, some field types are returned with two fields, the name of the field and the name of the field with Value appended, fieldValue.

The table shows the field types that I found that have a Value version. Other CRM field types only return one field and are of type String.

Multi-series charts


14 May 2014

When you create a chart with multiple series, the chart editor insists on adding a secondary y axis scale. This is probably something that you don't want because if you have two or more series comparing similar items the scaling will be different for each series.

There is no way to remove the secondary y axis scale in the editor. However, it can be removed by editing the chart XML. To do this:

Record GUIDs when duplicating a CRM database


09 May 2014

If you duplicate a CRM database using SQL Server (backup and restore) and the Import Organization wizard, record GUIDs are preserved.

Pages