CODEWITHSUNDEEP
excelsortingvisual-studio-2012ssrs-2012reporting-services-2012
smul86
smul86

Reputation: 411

Sorting in SSRS on Detail View

I'm asking on behalf of a coworker for this question.

She is using Visual Studio 2012/SQL Server 2012.

In EXCEL how you can sort easily from A-Z, Z-A and stuff of the sort in real time, is there a way to be able to do that in SSRS? Say a user drills from main view into detail view...is there a way with the info they can sort/mess around with it prior to exporting to excel?

Upvotes: 0

Views: 77

Answers (1)

Harry
Harry

Reputation: 2941

Yes there is.. Click on the header line for the column that you want to sort.. right click - Text Box Properties - Interactive Sorting then choose the Enable Interactive Sorting on this text box and then choose which field you want to sort by... when you run the report.. you will get an arrow next to the header that you can click to sort.. you can do this on multiple columns.. and if you wanted to sort by more than one column... you sort it by clicking on column one.. hold down shift and then the next column.. done.. the arrows do not print or export.. it's visible only on interactive view.

Upvotes: 1

Related Questions