In SSRS you can easily present users with database-driven single selection drop-down lists as parameters to pass to the stored procedure running your report. In the following steps I’ll go through the process of adding a single selection drop-down list to your report. Continue reading “SSRS: Adding a Single Selection Parameter List”
Category: SQL Server Reporting Services
SSRS: Simple Code Examples of Handling Null or Blank Date Fields
If you are looking for either null or blank values for a date field in SQL Server Reporting Services (SSRS) you will find that checking for IsNothing only identifies the Null values, but ignores the blank values. So what’s the quickest and easiest way to do this? Continue reading “SSRS: Simple Code Examples of Handling Null or Blank Date Fields”
How to Get the Current Year in SSRS
SSRS is a flexible platform for quickly and easily deploying reports. A handy set of functions is the inbuilt time handling. In this post I’ll give a quick overview of the options you have available for working with Date and Time values in SSRS, especially when it comes to getting the current year.