Strange sorting behaviour on series groups
Hi guys I'm seeing some very strange behaviour when trying to sort my series groups on a chart. I have an Analysis Services dataset with Job Grades and Job Grade Codes, the job grade simply being a concatenation of the Job Grade and the word "GRADE", e.g. 1 | GRADE 1 2 | GRADE 2 3 | GRADE 3 etc. I've pulled in the field Job_Grade into my Series groups section for a chart. I then tried to sort it by the key value which is the Job_Grade_Code like this: =Fields!Job_Grade.Key This produced the following result: Grade 6 Grade 7 Grade 8..... Grade 4 Grade 5 I noticed that the sorting was incorrect. I noticed that in the source the Job_Grade_Code field was a varchar value, so I changed the sorting expression to the following: =Cint(Fields!Job_Grade.Key) This however made no difference and still sorted my grades in the incorrect order. Any ideas? Thanks, Louis Louis Young
October 8th, 2010 3:52pm

Hi Louis, I think you might create this feature in the incorrect method, please follow these steps to recreate this feature: 1. Right-click the series datafield on the right side the chart, and then select Series Group Properties. 2. Switch to Sorting tab, click Add button 3. Select the sorting datafield in the drop-down list. 4. To order, you could select A to Z or Z to A based on your requirement. If the issue is still exist, please feel free to let us know. Thanks. Challen Fu
Free Windows Admin Tool Kit Click here and download it now
October 13th, 2010 10:38am

That's exactly the route I followed initially. I don't know what the problem was, but I resolved it by deleting the graph and re-creating it from scratch. It's working now.Louis Young
October 13th, 2010 10:48am

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

Other recent topics Other recent topics