SSRS - Sort report with drill-down rows.

Question

I'm setting the interactive-sort property in a cell, and in normal reports this lets me click to sort the rows.

I now have a report with multiple groups/drill-down rows, and the interactive sort doesn't seem to do anything. The rows stay in the same order.

Anybody had issues with this? Any solutions?

Answer 1

Me has the smae problems. Can't find a solution...

Answer 2

In Report Builder 2.0, right-click the column you're interested in, select Text Box properties, select Interactive Sorting from the left, and under "Choose what to sort" change from "Detail rows" to "Groups".