SSRS

KPIs in SSRS

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

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

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

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

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…


No Picture

Upcoming Speaking Engagements for Q4

In the next few months, I’ll be giving a couple of talks on SQL Server business intelligence.  For October, I have the pleasure of presenting for SQL Lunch, a new online learning series pioneered by Patrick LeBlanc.  On October 12th, I’ll be discussing ways to leverage SQL Server Report Builder 2.0 against your existing SSRS infrastructure to allow users to…