Archive for October, 2009

Reporting Services 2008: Axis labels not displaying on chart

October 7, 2009 6 comments

The new charts introduced in Reporting Services 2008 are fantastic. There are lots of new features ( explore the property boxes to see the new little tweaks that you can make¬† ), and of course the guages are proving to be very popular. In case you haven’t heard already , the SQL 2008 R2 release of Reporting Services will include Dundas Maps ( I’m already playing with this and will blog on it soon !! ).
Anyway , a minor annoyance with the current charts is that when you create a simple bar chart , for example , you don’t see all the labels on the bottom axis. For example , I’ve created a bar chart plotting sales by month. Without changing any settings , the default result is the following :

Right , so as you can see , the labels on the bottom axis are missing a few months. To correct this , it’s actually quite simple .

  • Right click on the axis in Design View , and select "Axis Properties"
  • Change the "Interval" setting from "Auto" to 1.

That should do it. You’ll end up with the following result.

Also play with the other settings , like "Interval Type" , "Arrow Style" etc. These Dundas charts really do give you options !!

Categories: Reporting Services