I've got an SSRS report that has interactive sorting on a handful of columns, and I could've sworn the sorting worked for years, but now I find the sorting buttons don't actually re-sort the report and have no idea why. Any suggestions?
I know it probably has something to do with the scope being wrong, but I feel like I've tried every possible combination and it still seems like it's evaluating the sort expression within the group? There table is just displaying detail. So it's sorting each row within the context of itself, instead of the whole dataset, which of course does not change the sort at all.