Category Archives: SSRS report

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 »

Phone Formating in SSRS report

Many a times there had been requirements to format the CRM phone number in the SSRS report in following format. We tried to achieve this by creating 12 text boxes and in each textbox we applied the below logic in the expression. = IIF(Fields!telephone1.Value.toString().Length>=1, GetChar(Fields!telephone1.Value.toString(),1), “”) It works successfully when the length of phone number is equal to… Read More »