Category Archives: SSRS Reports

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 »

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 »

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 »

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 »

Word, Excel or PDF, Now Exporting Reports in Dynamics CRM takes just One Click!

This is a part two of our Click2Export series. In Part 1 we have discussed some important features of Click2Export. Today we will see some common FAQ’s about our solution. Why Click2Export: Every business has the need for reporting. Click2Export provides you with a single click UI – Click, Create, Manage, Export Dynamics CRM Reports in… Read More »

Using LookupSet in SSRS reports to show activity parties related to an activity in Dynamics CRM

There are so many features of SSRS reports which are very less used but they can play a vital role in our report performance and productivity. One such feature of SSRS reports is LookupSet. SSRS Definition:  As per SSRS documentation a LookupSet may be defined as: Use LookupSet to retrieve a set of values from… Read More »

Converting Date/Time based on user timezone in SSRS reports for Dynamics CRM Online

Converting Date/Time values according to a timezone is quite easy in languages like javascript, C#, etc. but achieving this in SSRS reports is a challenging task. For CRM online we can achieve this using CRM parameter in SSRS reports. We have covered a work around to achieve this functionality in SSRS reports for CRM online.… Read More »

Using Indicators in SSRS Reports

It’s always a great pleasure for us to innovate and discover something which is very new but can be used at a large extent. This article is also based on a very interesting topic which can be used in SSRS reports to enhance the quality and overview of the reports and i.e. “Indicators”. Indicators are… Read More »