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”

JavaScript Helper Tool to Automatically Duplicate Elements in a List and Insert Code Between Them

Duplicate Text Tool
Duplicating List items and Adding Code Between them

In this article I will do something a bit different from my usual. Typically I review programming issues or topics of interest. In this case, however, I am presenting a handy new tool that will hopefully speed up a small, but time-consuming part of anyone’s development. That is, I have put together a tool that will let you separate a list of items, and duplicate each of those items several times while injecting code of your choosing between each duplicate as well as in front and in back. Continue reading “JavaScript Helper Tool to Automatically Duplicate Elements in a List and Insert Code Between Them”

Using Regular Expressions in SSRS to get the Server Name Portion of a URL

SQL Server Reporting Services (SSRS) has an in-built function called Globals!ReportServerUrl that allows you to return the URL of the SSRS report on the server. If you are looking at customizing part of your SSRS report depending on the Server that it is hosted on, then this is a useful function. Continue reading “Using Regular Expressions in SSRS to get the Server Name Portion of a URL”