Programming, Reports, SQL Server Reporting Services

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.

Continue reading “How to Get the Current Year in SSRS”

.Net, Programming, Regular Expressions, Reports, SQL, SQL Server Reporting Services

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”

.Net, Programming, Reports, SQL Server Reporting Services, VB.NET

SSRS Adding User Selectable Parameter Options

SSRS Params Drop Down
SSRS Params Drop Down

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 choices to the report results in various ways such as using the user selections to filter the results, or to hide and show results columns. In general, adding a dynamic, customizable aspect to your reports adds value for your users beyond spitting back a simple canned set of results.

In this example I will be working with a SQL Server 2008 SSRS set-up, but the general concepts hold true for related versions.

Continue reading “SSRS Adding User Selectable Parameter Options”