Dano
Dano

Reputation: 667

SSRS - Sort report with drill-down rows

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?

Upvotes: 0

Views: 2824

Answers (1)

Justin R.
Justin R.

Reputation: 24021

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

Upvotes: 1

Related Questions