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…
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…
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…
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…
I’d like to share with you a lazy efficient 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…
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…