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

Activities Report and Activities Detail Report - Circle Colours


29 Oct 2012

The out of the box Activites Report only shows activites that are regarding Opportunities and Cases.

The report includes an option to show all. This uses the Activities Detail report which includes colour coding against the activities.

By analysing the rdl file for the report the following sets the colour circle to show:

IIf(Fields!scheduledend.Value>DateAdd("d",7,Now),"ballgr",IIF(IsNothing(Fields!scheduledend.Value),"ballgr",IIf(Fields!scheduledend.Value>Now,"ballyl","ballrd")))

Troubleshooting Microsoft Dynamics CRM Reports


29 Oct 2012

I have written an article at Experts Exchange that on troubleshooting why reports don't work in CRM. Have a look and please leave your comments.

The article is at this link: http://www.experts-exchange.com/A_3552.html

Running negative queries


29 Oct 2012

Sometimes you need to get a list of records (say contacts) that don't have any related records of a particular type (e.g. appointments).
Unfortunately, this is not possible using Advanced Find as it can only return lists of records that have related records (e.g. contacts with appointments). Yes, you can narrow the related records (e.g. contacts with appointments after a certain date) but not to the extent of querying for contacts with no appointments.

"Unable to load client print control" error


29 Oct 2012

This appears to a common error when trying to print a Microsoft Dynamics CRM report. The discussion at this thread http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/4a4a2239-3ac5-4f1d-8b2d-b2c5f03d3c07/ has a lot of tips.

Note the suggestion to delete a registry setting seems to be the best.

rsProcessingAborted error for Report Wizard reports


29 Oct 2012

This article, http://support.microsoft.com/kb/2590774 describes a scenario where Report Wizard reports do not run.

Pages