Report Portal

Conditionally Hiding Axes for Trellis Displays

Over the last year MVP Tim Kent has put out a series of really useful posts showing how various data visualizations can be created using SSRS.

Trellis / Lattice displays
Win / Loss Charts
Bullet Graphs in SSRS 2008
Bullet Graphs in SSRS 2005
The latest post on Trellis displays got me thinking on how I could tweak a few of the settings in Tim’s very useful sample report just a bit more.

In order to show more sample data, I changed the top axis of Tim’s sample report to show sales Bike subcategories because as we all know AdventureWorks sells waaaay more bikes than anything else. Below is a shot of the original report after that change.


Tags: mdx, ssrs


2007-2015 VidasSoft Systems Inc.