SSRS - Sort report with drill-down rows

0
votes

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?

1
reporting-services

1 Answers

1
votes

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".