Tags » Sql Server Reporting Services

The future for me

I was reading through the email from The Databse Weekly and I saw an article from Paul Randal with regards to Paul being your mentor. This really got me thinking and where is my future within Business Intelligence (BI). 249 more words


Finding SSRS Reports Without A Data Source

When deploying reports to different environments it is possible to have reports not link to a data source. These reports are unusable and it can be time consuming to find them if there are a lot of reports. 263 more words

SQL Server Reporting Services

SSRS 2012 Report Manager can’t load Microsoft.ReportingServices.SharePoint.ObjectModel

So I did it again, I broke my SQL Server. Well, sort of. I have a Hyper-V VM of Windows Server 2012R2 I use for development. 486 more words

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. 103 more words


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. 806 more words


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.  776 more words


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

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. 306 more words