Need help for Multi Column sorting in Interactive Sorting

[Piyush Bhatt]

Hi Team,

 We are developing one report which works fine with single column sort via Interactive sorting.

-------------------------------------

http://www.telerik.com/support/kb/reporting/styling-and-formatting-reports/details/how-to-add-interactive-sorting-to-a-table-item-

-------------------------------------

Now here we are facing issue for multicolumn sorting. we need multiple column to sort via Interactive sorting only and yes we need it to work in HTML5 report viewer.

 

Thank You.

[Stef]

Hi Piyush,

The approach in the How to add interactive sorting to a Table item KB article is applicable for more than one column (please check the last three steps of the tutorial).

More details about the approach are available in my post here - Interactive sorting in TRDX reports.

Regards,
Stef
Telerik

[Piyush Bhatt]

There is some technical issue with this whole sorting approach and not sure what we are doing wrong.

 We are using MVC HTML5 viewer. The report has default values for report parameters that are used only in design. When the report is integrated in the application, we use JS methods to get the actual parameters and pass it to report. but when we click on the column header, the report displays with the default parameters and not with the parameters used last from the application.

 I can see this via Fiddler and Network tab in browser that as soon as Column header is clicked, it makes a call to 'parameters' for the web-api with the default parameters instead of the last set of parameters that report was open with.

 We tried with both persistSession-true/false but no luck. In the history of the session-storage, the first parameter is the default report parameters and then it stores the parameters as the report was refreshed or initialized with. I fail to understand why it uses the report's default parameters and how to tell it to not use it at all.

 

[Stef]

Hi Piyush,

Please check if Newtonsoft.Json.dll is not installed on the machine. If it is, remove the assembly from the GAC and install it via Nuget packages manager to the latest available.

If you need further help, please open a support ticket and send us a demo project to check the settings.

Regards,
Stef
Telerik