Tag: Fetch-XML

SSRS convert UTC datetime value to local datetime

For any Dynamics 365 developer, at one point in time they might encounter issues with the datetime fields in CRM. The challenge always comes when we working on backend, because there is always a confusion in the mind whether the date time value is UTC or local time. When working in reports, fetch-xml dataset have … Continue reading SSRS convert UTC datetime value to local datetime →

SSRS Fetch-XML query report with requirement to transform rows to columns

Creating custom SSRS report is inevitable when there is a requirement to manipulate data that you can't achieve it using report wizard or saved query. The custom report is very good old feature of the CRM that is will come to rescue. Custom report development in On-Premise version of CRM have added benefits and challenges. … Continue reading SSRS Fetch-XML query report with requirement to transform rows to columns →