Dashboard navigation is the phrase i am using to describe the process of being able to interrogate and drill down into reports without the necessity for using parameters. Let's face it, parameters are really ugly in SSRS - even with the ability to now lay them out - and the world would be a happier place if there was such a concept as slicers and other report UI elements natively in the SSRS universe. Firstly a note: yes, I know Power BI does a lot of this stuff. However, for on-premise customers, this isn't necessarily a cost-effective solution. Most of my customers are SharePoint and Project Server users and - lets face it - most Project Server environments don't end up sitting on SQL Enterprise Edition so Power BI requires $/£ on top of the existing customer investment, which just isn't gonna fly in most cases. So here are a few concepts I have played with in the last few weeks to spoof such navigation tricks. Part 1) Single-select slicers using
sharing the love