Justin Cooney

Web Development Tips and Examples

recent posts

about

I am a Senior Applications Programmer / Analyst with years of experience developing enterprise solutions using the Microsoft technology stack including C#, VB.NET, ASP.NET, AJAX, IIS and SQL Server. I specialize in Web application development with a focus on building secure systems, integrating applications, and designing robust database structures.

Category: Reports

  • 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.

  • 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.

  • SSRS Adding User Selectable Parameter Options

    SQL Server Reporting Services (SSRS) is a handy tool for generating reports quickly. However, like most reporting packages, making the reports dynamic rather than simple static canned reports takes a bit of effort. For example, you may want to let the users of your report choose from a list of options. You could then apply these…