Introduction SQL Server Reporting Services (SSRS) is Microsoft’s offering in the reporting space, if you install SSRS as part of a SQL Server install you get a nice web front end through which users can navigate and view reports. But SSRS is not restricted to this online portal style access, reports can be embedded into … Continue reading Emailing an SSRS Report using ReportViewer
SSRS
Searchable / Dependant Parameters in SSRS
Introduction The idea behind this post came from a question from a colleague, they wanted an SSRS report where they could select from a list of employees but the list could be filtered by searching on the surname (i.e. you enter ‘S’ and it would load a dropdown of all employees whose surname start with … Continue reading Searchable / Dependant Parameters in SSRS
SSRS Custom Code (Expressions, Embedded Code & External Assemblies)
Introduction In this article we will look at the options for using custom .Net code in our Microsoft SQL Server Reporting Services (SSRS) reports. This post assumes you have a working knowledge of SSRS. There are three main ways to use code to help generate our reports, in increasing order of complexity (and therefore flexibility) … Continue reading SSRS Custom Code (Expressions, Embedded Code & External Assemblies)
Horizontally Centred Dynamic Images in SSRS
Centring Dynamic Logos in SSRS This was an interesting problem I ran into the other day, basically I have a report that displays data on a range of businesses. The report then needed a dynamic header to display the logos for each of the businesses that feature in the report. The number of businesses could … Continue reading Horizontally Centred Dynamic Images in SSRS