Interactive Sorting

[Michael Epley]

I need to add Interactive sorting to my Crosstable report.  Will the new Q2 Interactive functionality allow that to be done?

thanks
-Mike.

[Ivan]

Hi Michael Epley,

You can accomplish dynamic sorting of reports fairly trivial with the new interactive functionality of Telerik Reporting. The trick is to define an Action that navigates to the same report and passes a parameter indicating by which column to sort. Then you can use that parameter in the sorting criteria of the report. To illustrate this I have attached a small sample project with two reports:

• The TableSorting sample report demonstrates how dynamic sorting can be accomplished for a Table with a fixed set of columns.
• The CrosstabSorting sample report demonstrates how to achieve the same thing for a Crosstab with dynamically generated columns.

You need the Adventure Works sample database that comes with each installation of Telerik Reporting in order to run these reports.

Greetings,
Ivan
the Telerik team

[B]

thanks for the example.  but...it looks like you hardcoded sort by ASC.  typically sort ASC or DESC can be toggled by allowing the user to click on the same column a second time...reversing the sort order.  How would you implement that using a ReportAction?  Can this be done with ReportActions?  Thanks!

[Peter]

Hi B,

A similar topic about interactive filtering with direction toggle has been discussed in the Click column forum thread. Check it out and let us know if you need additional assistance.

Kind regards,
Peter
the Telerik team

[Peter]

Hello,

This is supported out of the box from R2 2016 official release. For more information check out the documentation.

Regards,
Peter
Telerik by Progress