I'm generating charts based on the output from SQL, I have the SQL set to sort the output in a certain order, but when the Report Designer is displaying the chart, It's sorting the legend alphabetically. I must have my legend in the format:
Which is exactly how my SQL is outputting the data. I've even added an addition ORDER BY statement in the SQL statement INSIDE the designer and it's not working.
Apparently you can you can fix this with the expression editor, so please provide me the syntax / code to do this, I must have the legends in this format.
To quote the documentation in your own system:
"Items are ordered in the legend according to the order that they are processed by the processing engine. You can change the order by changing the Graph.SeriesGroups SortingsExpression or Direction."
How is the chart processing the data in the wrong order, being I delivering to the system in the exact order it should be processing it.