Tip #629: If your CRM report comes back empty

We observed this behavior on CRM 2013 SP1 and and CRM 2015 Update 0.2 on-premises. The report runs fine for small ranges (e.g. dates) but, as the range (and number of records to be processed) increases, report comes back blank, as if it didn’t run at all. No errors in CRM, SQL Server or SSRS […]

Tip #618: Mute power or powerless voice

Voice of the Customer breaks PowerBI

If you’ve been following our Voice of the Customer videos, you may have been tempted to install the solution and try it for yourself. For those of you using PowerBI to do some cool reporting on your CRM data, a timely word of warning from Jukka “Survivor” Niiranen: Currently there’s a known issue with the […]

Tip #447: To filter or not to filter – functional view

This seems to be the week of unsupported tips. I know, we said it before: Swim between the flags, and Use filtered views even if you use stored procedures. But what do you do if this particular report’s query is a monstrosity, adding custom indexes don’t help, and any attempt to restructure it just makes […]

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 #380: Sort the chart by aggregate

Another mini truck stop. It seems that Adam “I bought the truckstop” Vero has become a regular despite his tendency of giving the answer first, asking the question later. Our own Joel “Pretend I know nothing” Lindström asks: Scenario: You have a chart of number of opportunities by opp type. How do you sort/order by […]

Tip #358: How to delete deleted report

Import renamed report

No, it’s not a typo – I am going to talk about deleting the deleted. – “What?!” Let me explain. We all have that Rupert/Vernona/Joe/Jill on our team who think they know best and, for some inexplicable reason, management agreed and granted them privileges sufficient to deliver some real damage. Like going into SQL Server […]