Document Map makes navigation is easy to navigate through table in SSRS In our case we have dataset which contains Product and Product Subcategory. We created the 2 parent groups on Product key and Product Subcategory key. We have to go in the Parent group(ProductCategoryKey) >Advanced > Document Map and select the column used for … Continue reading Creating Document Map in SSRS →

In this article, we will create a Gantt Chart or Progress bar inside a table in SSRS . In SQL Server Reporting Service does not allow a report programmer to modify a “width” property at run time. The challenging part of this task is how to create a scale and how to create a progress … Continue reading How to create a Gantt Chart or Progress bar inside a Table in SSRS →

Introduction: Once a User exports a report to Microsoft Excel from a Microsoft Dynamics CRM environment, they may want to further filter the report in Microsoft Excel. Issue: An issue I came across recently was that the report, when exported to Excel, would not allow me to filter in Excel for the first few columns, … Continue reading Filter Error In Excel While Exporting SSRS Report From D365 CRM To Excel →

Problem: There is no in-built function in SSRS where we can count the number of Saturdays and Sundays between any two dates in SSRS. This is a needed function for scenarios where we only need to get a count of working days.’ Solution: Following is a formula that can be used for getting an accurate … Continue reading Count Number of weekends between 2 dates in SSRS →

Introduction: It is possible to Fetch images from CRM’s entity records using Fetch XML.  This can be done using Notes attachment in CRM and the steps to display the Image in your report are pretty simple as well. Steps: Attach your image to a note under your respective entity in CRM In your Visual Studio … Continue reading Generating Image dynamically in SSRS Report from CRM →

Issue: If you are trying to preview a FetchXML report in SSRS and you are a facing an issue due to a Sign-In Failure, then the reason for that most probable is due to the reason that you are trying to connect to CRM v9. When we try to connect to a v9 environment using … Continue reading SSRS Report Preview not working for D365 CRM V9 (Solution) →