Forum Discussion
Sorting column chart in Report Builder not working
I have a simple column chart I built in report builder, and need to change the sort order of the x axis, but nothing will make the change "stick". The chart shows sales by currency, with sales on the...
I resolved the issue (in a Table report, not a chart report) by downloading the Reporting Service report .rdl file and using a text editor (notepad) to find the Group Expressions. In this image I changed the field in the SortExpressions node to be the field in my dataset I wanted to sort on. Saved my changes, uploaded the .rdl file back into the Report Builder to continue editing, and never had the sorting issue again.