Each week, I take a look at my website statistics in Google Analytics, and I view the top 25 blog posts. Without fail, at least one or two of them relate to writing reports using FetchXML, a proprietary query language used in the Common Data Service. If you are a Dynamics 365 user, you might … Continue reading SSRS Reports For CDS & D365 Using FetchXML
I’ve written previously about the joys of setting up Visual Studio and heading down the path of writing Dynamics 365 Reports using SSRS. Once you get through that, then the world is your oyster in the reporting sense. Getting the query to start with is done by opening the Advanced Find, creating your search then … Continue reading Creating Dynamics 365 Reports With Multiple Entities
For various reasons, I’ve had to install Visual Studio on a laptop several times over the past year or so. Maybe it’s just bad luck, but I have had issues each time, and each time I’ve been my only line of support to figure out how to resolve those issues. I thought it might be … Continue reading Too Many Issues To Count – Creating Reports In Visual Studio
While writing FetchXML reports recently, I experienced a strange date parameter issue. Running the report was fine in Visual Studio, I could pick any date range and the report would run without errors. Once published to CRM, it failed under certain circumstances. For example, keep in mind that I am in the United Kingdom where … Continue reading Date Parameter Issue With FetchXML
After finding this great article online for creating 3D charts in CRM, I wondered what else I could change. Start off by Exporting the chart. The FetchXML will download. Open it up in an editing tool, Notepad works fine. There are quite a few elements that can be adjusted, and many articles online. By changing the … Continue reading Use FetchXML To Modify CRM Charts
If you have written CRM reports in SQL using SSRS, you are probably familiar with adding the pre filtering using CRMAF_ to your query (check out this great article if you aren’t).This allows you to set default filters using Advanced Find which users can adjust if needed prior to running a report. Makes it very … Continue reading Adding CRM Filters To FetchXML Reports
Having written many SQL reports using SSRS, the first time I stepped in to the world of writing FetchXML reports for Microsoft Dynamics 365, I made a lot of assumptions. Using a SUM aggregate was one of them. I figured it would be as simple SUM(currencyvalue) just as it is in SQL.