There are 26 system SSRS reports (not counting subreports) that come with Dynamics 365. If you find one that is close to what you need (like the quote report), should you modify the system report? I say no. Here is why: System reports currently in Dynamics 365 are the same system reports that were in […]
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 #352: When you can’t publish a report
Sometimes when writing SSRS reports for CRM, you will find that the report works fine in Visual Studio, but will fail when you upload them to Dynamics CRM. This can be frustrating, because it can sometimes be difficult to identify the cause of the issue—it works fine when you preview it in Visual Studio, but […]
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
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. […]