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 #409: Make Tip #380 work for option sets

In tip 380, Adam Vero explained how to make a chart sorted by the aggregate sum or count. This is a great tip, except it didn’t work for one of my clients when the chart was grouped by an option set. Perplexed, I tweeted The CRM Chart Guy. He acknowledged that this was an issue, […]

Tip #283: Create a limited customizer role

In most deployments, users who need to manage customizations in an environment are granted the System Administrator or System Customizer role. This gives them the ability to create or edit entities, relationships, fields, views, charts, dashboards, the whole enchilada. But what if you want a nibble of the enchilada? Not all customizations carry the same […]

Tip #196: Why can’t I funnel or pie?

I received an excellent question this morning: “Dear Tip, why can’t I do a funnel or pie chart? These buttons are grayed out!” The reason the buttons for funnel and pie are grayed out is because the chart definition includes multiple categories. Pie and funnel charts only support single groupings (series and category). When doing […]

Tip #60: Remove Decimals From Charts

In Microsoft Dynamics CRM 2011 or 2013, when you have a chart summarizing a decimal or currency field, by default your chart values will contain decimals. What if you want to round to whole numbers? To do this, you will need to export the chart XML. For a system chart, navigate to your solution to […]