SSRS working with multiple datasets in same table control

Dataset as the name implies it is set of data that are result of the query that is set in the query area of the dataset configuration. In certain times we can't able to resist creating multiple datasets in a single report. Once such case is using D365 FetchXML datasets, the limitation causes the reason … Continue reading SSRS working with multiple datasets in same table control

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

Launch a New Entity Form within a Modal Popup with Data Prepopulated

In certain cases, there's a need to open a new form filled with prepopulated data, which could be derived from a parent record or set to specific default values. The NavigateTo method is designed to streamline this process, allowing for seamless navigation to a chosen table list, table record, HTML web resource, or custom page, … Continue reading Launch a New Entity Form within a Modal Popup with Data Prepopulated