Programming, Reports, Software, SQL Server Reporting Services

SSRS: Adding a Single Selection Parameter List

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”

Advertisements
Programming, SQL, SQL Server Reporting Services, SQL Tips

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”