SSRS Chart X Axis labels not in order
Hello, My column chart x axis labels are not in order. They should be "2005 2006 2007 2008 2009". Instead, they show up as "2006 2009 2007 2005 2008". How can I edit this so they are in number order? Thanks! JohnJohn C. Hill
April 28th, 2011 10:15am

Please check this http://social.technet.microsoft.com/Forums/en-US/sqlreportingservices/thread/ffafa0a6-13ec-4816-bcb9-0ea8028214af#5e98efc9-689d-49f6-ac1b-519912e778adhttp://uk.linkedin.com/in/ramjaddu
Free Windows Admin Tool Kit Click here and download it now
April 28th, 2011 10:22am

Thanks but I don't think I found a solution there. I have two charts that are exactly the same ( I copied one and made the second). The only difference in the two is one has a parameter value of 'Revenue', the other has 'Expenses'. They both pull from the same query so nothing is different there. The Expenses chart does not put the dates on the X axis in date order while the Revenue chart does. This is driving me crazy. Any ideas are much appreciated. JohnJohn C. Hill
April 28th, 2011 10:53am

if you check the fields propeties (the x axis category group) that displays the year and add sorting with an expression of year(fields!date.value) , That should order by the year value of the field . you could try that and see how it goes
Free Windows Admin Tool Kit Click here and download it now
April 28th, 2011 11:58am

Perfect. Thank You!John C. Hill
April 28th, 2011 12:37pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics