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 […]
When you merge two records you may receive the following cryptic message: A record that has the attribute value {1} already exists. The entity key {0} requires that this set of attributes contains unique values. Select unique values and try again What? Select where? That’s really confusing because the merge process is supposed to ignore […]
We did talk about wildcards and using some unorthodox search techniques before. But today’s tip is not a revision but rather an extension. In one of the projects we had the need to find all contacts whose last names contain spaces (if you must know, that’s because last names were used as a base for […]
One of my favorite things about the Dynamics 365 Outlook App is the way that recipients are displayed in the app pane, and how easy it is to update or create contact records in CRM. This makes it very simple to identify when contact information is missing and validate that we have complete contact information […]
One of the key features of Dynamics 365 is the choice of the deployment platform: go online, on-premises or partner-hosted. With Dynamics 365 Online leading the way, licensing has evolved beyond simplistic “pay-per-server-plus-cal” model of the past. For penny savvy customers, the recommended bedside reading is Dynamics 365 On-Premises Enterprise Edition Licensing Guide. If you […]
We did write about pending alternate keys in tips 894 and 894 + 3 and that it’s easy to reactivate the pending keys using solutions UI in Dynamics 365. However, as David “Xrm.Tools” Yack reports, sometimes pending keys are really stubborn and pressing Create Index generates very introspective and philosophical “Exception: Event failed due to […]
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 […]
So you log into Dynamics 365 and open a record, like an account, and the activity tab of the social pane is blank. If this happens to you, clear your browser cache, then re-launch your browser, log in, and try again. If your activities are still missing in IE after clearing your browser history, try […]
Recently on the Dynamics CRM Facebook group, Rana Potter asked if it was possible to search within attachments from CRM. The winning answer came from Niran Belliapa: If you are using Dynamics 365 Online and have the December 2016 update you can use the Relevance search feature. You’ll find search results for text in a document […]
This great tip comes from Katina Hester. (And you can submit your tip too – just email it to jar@crmtipoftheday.com!) Here are a few tips to keep in mind when configuring the Dynamics 365 data export service that might not be obvious: When setting up the DES profile, the MSFT provided steps for copying the […]
of the