O'Reilly logo

SQL Server 2012 Reporting Services Blueprints by Mickey Stuewe, Marlon Ribunal

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Aligning axes in the sparkline

Take another look at our report above. Something is amiss, right?

Compare the sparkline series between Canada and France. Canada has twelve (12) bars on its categories compared to France's six (6). What this tells us is that France has sales data only on the half of the year (six months). But which half: first or second?

That's hard to tell the way our Sparklines is presented in the previous report.

We want to align each and every bar so we can tell which months have no sales data or which month is missing data, whatever the case is.

Let's fix that.

Going back to the report designer, select and right-click on the sparkline, then select the Horizontal Axis Properties option from its context menu, as shown in the following ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required