Tip #928: When CRM monthly charts won’t render

Just another pie chart

In Dynamics 365/CRM on premises, if you create a chart and group by month and find that it doesn’t render, you may need some additional SQL permissions. Database owner must have external access assembly/unsafe assembly permission SQL database Trustworthy property must be set to “on.” With these settings in place, your monthly grouped charts should render […]

Tip #917: Too many business units

Microsoft org chart

Someone recently asked me what I thought of someone adding 1,000 + business units to Dynamics 365. I told them it was a bad idea. Here’s why: Business units are like large granite rocks–they are designed to be permanent and infrequently moved. While users can be moved between business units, it is not a trivial […]

Tip #554: Recently Visited Items in Outlook Client

One fantastic time saving feature in Dynamics CRM is recently visited items. In CRM in browser, if I click the drop-down arrow by an entity tile, I will see the recently viewed records for that entity. But what if I’m using CRM for Outlook? There is not drop-down to display the recently visited records. But […]

Tip #446: How to avoid overwriting audit and duplicate detection flags

Audit On/Off

tl;dr To avoid overwriting some of the system entities flags for the customers, manually remove those flags from the managed solution files. WARNING! Super-duper unsupported. Some juicy details If you are a Dynamics CRM ISV or an infrastructure group within a large enterprise then, most likely, you distribute one or more managed solutions to your […]

Tip #430: Read Only Users and CRM for Outlook

So you have users that have a read only/limited user access type. But you want to have them use CRM for Outlook to provide consistent user interface with your other users for consistency in your training and user documentation. The problem, however, is that the configuration wizard for CRM for Outlook requires write access to CRM […]

Tip #417: Cancel waiting instances in style

We have posted multiple times about waiting workflows, and one of the big challenges surrounding them is that when you update a workflow definition, there is no way to cancel the waiting instances of the workflow in bulk. Also, jobs may go into waiting state if there is a condition that prevents the step from […]