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