SSRS

Using the JOIN Function in Reporting Services

The JOIN() function in SQL Server Reporting Services is a handy tool that allows you to turn a list into a delimited string value. This function accepts two parameters, a list and a delimiter with which to separate the output, and returns a string with that list separated by the specified delimiter character. Using the JOIN Function in Reporting Services…


KPIs in SSRS 2016

Key performance indicators, or KPIs, are at-a-glance metrics for simple insight into the business. These are each designed to provide a glimpse into one aspect of a measurable business activity. KPIs are present in various implementations in most every reporting tool, including SQL Server Reporting Services. Until recently, KPIs in SSRS were not a native part of the SSRS reporting…


Report Portal in SSRS 2016

SQL Server Reporting Services benefits from a major update in SQL Server 2016, which is obvious from the first interaction with the product. The old and bland Report Manager interface has been replaced with a more modern portal that more effectively displays at-a-glance business answers. In this post, I’ll describe some of the improvements in the all-new report portal in…


SSRS 2016: Great and Getting Better

Although I’ve been a regular user of SQL Server Reporting Services since it was released in the mid-2000s, I’ve done very little blogging about it. In fact, a quick search on my blog reveals that it has been almost five years since I wrote an SSRS-specific blog post. But let’s be fair – before this year, it has been a…


Conditional Default Values in SSRS

I’d like to share with you a laziness efficiency method I use when developing reports in SQL Server Reporting Services. By using conditional default values in SSRS, I end up saving a significant amount of time during development and testing my eliminating the time required to manually enter parameters. Conditional Default Values in SSRS I’ve found that it’s quite common…


Report Parameter order in SSRS

Is the order of parameters important in SQL Server Reporting Services reports?  If you’ve got nested parameters (parameters that derive their value from one or more other parameters), it is very important! In this post, I will show that report parameter order in SSRS matters a lot when parameters are dependent on each other. Report Parameter order in SSRS Using…