Tip #960: If your FetchXML-based report preview is not working

You are writing a FetchXML based custom SSRS report . When you click the “preview” tab in SQL data tools, the report runs without error, but does not display correctly. Maybe there are records missing, or you enter a parameter value that should return data, and it does not display any results. Is your report wrong? […]

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 #347: How to use datetime fields in WHERE clause

Gotta love user Q&A sessions, like the one at Convergence 2015 that I had a privilege to take part in. Questions from users are always refreshing, very often challenging and sometimes they are just the reminder that any small bit of information that one possesses is not necessarily the common knowledge. On this occasion question […]

Tip #310: CRM 2013 to CRM 2015 Upgrade Gotcha #1

SQL Server Reporting Services Connector Uninstall Warning

Thinking about doing an in place upgrade from CRM 2013 to CRM 2015? If so it isn’t just a matter of running the SetupServer.exe file. That is even assuming that your underlying infrastructure supports CRM 2015. One notification that you run into immediately is the pre-requisite to uninstall the CRM Connector for SQL Reporting Services. […]