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

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.

Table alias is not unique amongst all top-level table and join aliases


15 May 2014

If you are seeing the above error, it might be due to incorrect FetchXML in the definition of a saved query such as a Quick Find view. I've encountered this on CRM 2011 with UR13 installed after modifying the filter criteria for a Quick Find view. The view includes fields from related entities.

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