ws01 Report post Posted January 23, 2013 I DrillDown a MainChart in months, but the order in wich months appear on X-Axis isn't correct. Data Provider for the Chart is a SharePoint List. Please see screenshot at attachement. Thxs for help ... Share this post Link to post Share on other sites
Rahul Kumar Report post Posted January 23, 2013 Hi, I am afraid, you missed to attach the screen shot. Regarding the issue, could you please make sure that the column type for Month field is of DateTime Data Type? And could you please also post the screen shot of the wizard after moving to "Select Fields" step and highlighting the columns which you use for Grouping and Drill-Down? Share this post Link to post Share on other sites
ws01 Report post Posted January 23, 2013 (edited) Hi, I am afraid, you missed to attach the screen shot. Regarding the issue, could you please make sure that the column type for Month field is of DateTime Data Type? And could you please also post the screen shot of the wizard after moving to "Select Fields" step and highlighting the columns which you use for Grouping and Drill-Down? Hi, column type for month is "Choice" , and the 12 monthes are listed in the Choice-Window. If the column Type is DateTime users can't enter a month ? I attached the differents screenshots. ?I'm working in a german country, so: "Monat" = Month . Thanks for helping me ! Edited January 23, 2013 by ws01 Share this post Link to post Share on other sites
Rahul Kumar Report post Posted January 24, 2013 Hi, Thanks for the information. We have checked the scenario but I am afraid, it would only if the column type is Date and Time. Share this post Link to post Share on other sites
ws01 Report post Posted February 5, 2013 Hi, Thanks for the information. We have checked the scenario but I am afraid, it would only if the column type is Date and Time. Hi, Sorry for delay ! I don't understand, if column type is Date and Time I can't type in a month ? Best regards Share this post Link to post Share on other sites
Rahul Kumar Report post Posted February 5, 2013 Hi, What I mean is if type of column is not datetime, the code will not be able to identify whether the data inside that column is datetime value or plain text value. And even if we forcefully check and convert words like 'Jan', 'Feb', 'Mar' etc to datetime fields there'll be still issues which can arise such as: 1. Conflict with the Month name e.g. 'Jan' or 'January' 2. Things will be more complicated if data contains month text in different language other than English. Share this post Link to post Share on other sites
ws01 Report post Posted February 6, 2013 Hi, What I mean is if type of column is not datetime, the code will not be able to identify whether the data inside that column is datetime value or plain text value. And even if we forcefully check and convert words like 'Jan', 'Feb', 'Mar' etc to datetime fields there'll be still issues which can arise such as: 1. Conflict with the Month name e.g. 'Jan' or 'January' 2. Things will be more complicated if data contains month text in different language other then English. Hi, I understand, Thanks for your help. Best regards Share this post Link to post Share on other sites
Rahul Kumar Report post Posted February 7, 2013 You are welcome. Share this post Link to post Share on other sites
