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

ASP.NET, Programming, Reports, Software, SQL Server Reporting Services, Visual Studio 2013

SSRS Basics: Set up Visual Studio to Write a New SSRS Report

SSRS with Visual Studio
SSRS with Visual Studio

When first looking into writing SQL Server Reporting Services (SSRS) Reports in Visual Studio, it’s easy to think that creating a report will be possible straight out of the box with one of the existing templates that Visual Studio comes with. Somewhat surprisingly, this is not the case for Visual Studio 2012 and 2013. Continue reading “SSRS Basics: Set up Visual Studio to Write a New SSRS Report”