I've a dataset with year, month and a count. Building a chart on this data is no problem. The dates are sorted well. But if i add a field to dataset the ordering is gone and when i delete the field from the dataset, the ordering is still not right. So i'm trying to force the ordering in the chart but it's not working. What am i doing wrong? Perhaps i'm making a bad assumption about datasets. I want to used a dataset for multiple charts on my report for a one pass approach to the db. Hennie Update: I have a long trend diagram with years and months. I want to show monthdescriptions (and year) and sorting based on the order of months. When i'm writing this update i noticed that the order is januari, october, november, december, februari and so on. It has something to do with the datatype of montnumber field. I'll investigate further...

Well, The report is build on a cube and in the datasource view it's an int but i can't find any datatype indication in Reporting Services (Query designer and dataset). Okay i've converted the field to int with a Cint function and it works. But this is a workaround in my opinion. Where can i set/view the datatypes in the query designer or dataset???

Hi Hennie7863, We could not set/view datatypes in the query designer or dataset if you are using SSAS as datasource, you have to view it in cube, to your original question, you could add a sort field(Int type) to the group, for more information about sort in reporting sevices, please see: http://msdn.microsoft.com/en-us/library/dd220417.aspx#Sorting Thanks, Challen Fu Please remember to mark the replies as answers if they help and unmark them if they provide no help.