Chapter 11SSAS Reporting Advanced Techniques

In 2005, I presented a session on report design at the PASS Global Summit. After the session, a very distinctive character came up and introduced himself. He was a tall gentleman with an Aussie accent, wearing a leather outback hat and a permanent smile. Grant Paisley and I have been good friends ever since. We found we had much in common, including a passion for taking technologies like Reporting Services to the edge. If there was ever an out-of-the-box thinker, it is Grant. He has done things with SSRS that are simply unimaginable. His cube browser solution, which he has been evolving and improving for years, blew my mind. It is a remarkable example of the flexibility afforded by Reporting Services paired with Analysis Services and some ingenuity.

Grant contributed the content of this chapter in the last edition of our book with a collection of reports sewn together using actions, expressions, and parameters. It all works in SSRS 2016 exactly as it did in 2012 with only minor adaptations to the sample project, which is called Wrox SSRS 2016 Dynamic Cube Browser. Having used these and similar patterns in a number of my projects, I encourage you to review ...

Get Professional Microsoft SQL Server 2016 Reporting Services and Mobile Reports now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.