Category Archives: SSRS Reports

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 »

Show different Header/Footer on different pages of SSRS report

Sometimes, there are requirements to show different Header/ Footer on different pages of the report. Like say, on the first page, header/ footer of report should be some text and on the second page it should be some different text. Please refer below screenshots. First Page Footer Second Page Footer This can be achieved using the… Read More »

Display more than 2000 characters in SSRS report

We would like to share one of our experiences with SSRS reports. One of the reports we were building required displaying of notes that could hold more than 2000 characters.     Including a text box worked fine for most of the records but we observed that the ones that had more than 2000 characters… 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 »