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 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 »
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 »
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 »
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 »
We created a SSRS on-premise report using CRMFiltered parameter and the report was working fine except for the case when we ran this report on more than 25 records. In that case the report was crashing. When we used Diagnostic Tool then we found the below error. The error was that it was concatenating the… Read More »
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 »
Email body in Dynamics CRM is stored in HTML format and when we try to display the data as is in the SRS report, it shows up with all the HTML tags.Microsoft Dynamics CRM reports strip the HTML content and display it in Plain text format.Now with SSRS 2008, you can display them with part… Read More »
There have been times where you need to provide a different header on one page and another on the second page or say every alternate page. This concept has been provided in MS Word, where you are allowed to setup a Odd Page Header and an Even Page Header. Should you want to incorporate this… Read More »
There are times when you would like to restrict the number of rows that are being displayed on one page in a table. By default if you add a table to a report and set the datasource to a dataset, it will list out all the rows of the dataset in there and if the… Read More »