Category Archives: SSRS Reports

How to Navigate from One SSRS Report to Another in SSRS Report

In SQL Server Reporting Services (SSRS), actions play a crucial role in enhancing report interactivity and making SSRS reports more dynamic. They enable users to perform specific tasks or navigate to different content by clicking on designated areas within the report. SSRS supports three types of actions: Go to Report, Go to Bookmark, and Go… Read More: How to Navigate from One SSRS Report to Another in… »

Displaying entity image in SSRS report using Power Automate

In Dynamics 365 CRM, while working on one of our requirements we came across a scenario where we needed to display an Account entity image on an SSRS report. But, due to SSRS limitations, the report did not allow the usage of the OOB “entityimage” attribute in the dataset. As a workaround we’ve created a… Read More: Displaying entity image in SSRS report using Power Automate »

How to Convert Currency Field Value as per logged in user’s Currency setting in SSRS

Introduction In this blog, we have explained how to convert currency field value as per the CRM logged-in user currency setting. Thus, it would be helpful for user to get the converted amount in their selected default currency. For example: User ‘A’ entered the amount as USD 10 and User ‘B’ have default currency as… Read More: How to Convert Currency Field Value as per logged in… »

How to use Image Web Resource of Dynamics 365 CRM in SSRS Report

Introduction We use images in reports which were taken as external images from notes or from entity image of CRM. In this blog, we will see how we can use image web resource of CRM in SSRS report. Consider a scenario where in a report, we need to show different images depending on logged in… Read More: How to use Image Web Resource of Dynamics 365 CRM… »

Get Specific Filter Parameter Value in SSRS Report – Dynamics 365 CRM

Recently, we had a business requirement in which one of our clients needed some modifications in report. So as we all know, SSRS reporting tool is most widely used to make customizations in the report. Requirement: User should be able to see the updated report header based on, the value selected for the field in… Read More: Get Specific Filter Parameter Value in SSRS Report – Dynamics… »

Working with Report Pre-Filtering for related entities using Fetch XML

Introduction: Pre-filtering is one of the most important and useful features of reports in Microsoft Dynamics CRM. Pre-filtering allows filtering of the report data using the Advance Find functionality and enables users to create context-sensitive reports and return more relevant data. Pre-filtering passes the set of selected record or a specific record (such as Quote)… Read More: Working with Report Pre-Filtering for related entities using Fetch XML »

How to debug rsProcessingAborted Report Error?

Introduction: rsProcessingAborted Reporting Error is one of the most dreaded error faced by SSRS report developers. What could be the cause of this error? How to solve this? Why did this error originate? These are few of the multitude questions that goes through the developers mind. We have been in the same position. We had… Read More: How to debug rsProcessingAborted Report Error? »

How to show signature accepted using Pen Control in Reports & HTML web resources – Dynamics CRM/365

Introduction In our earlier blog, we explained about how we can use newly introduced Pen control in Dynamics 365. This is an impressive feature, which helps to capture the signature on mobile and tablet devices. While working with Pen control, we came up with couple of questions, Display the drawing/signature on the report For example,… Read More: How to show signature accepted using Pen Control in Reports… »

Missing Reports from certain users in Microsoft Dynamics 365 for Sales aka Dynamics CRM

Issues: Ever been in a situation when you have deployed a report, made sure it is available for the organization and yet you have a user complaining of the missing report. Cause: You have users that use different languages as their UI language. While uploading the report, it was uploaded with a specific language set.… Read More: Missing Reports from certain users in Microsoft Dynamics 365 for… »