How to Enable Column Sorting in Reports Created with Advanced Pack?

[smachado]

Hello,

I'm currently using EspoCRM with the Advanced Pack, and I would like to know how to enable sorting for columns in reports created using this extension. Specifically, I want to allow users to click on column headers in a report (e.g., "Revenue" or "Customer Name") to sort the data dynamically in ascending or descending order.

I've explored the report.js and column.js files, but I haven't found a clear way to implement this functionality. Is there a built-in feature in the Advanced Pack to achieve this? Or, do I need to customize the frontend and backend to handle sorting parameters like sortBy and sortDirection?

Any guidance or examples would be greatly appreciated. Thank you!

[yuri]

Hi,

Unfortunately, there's no built-in ability to re-sort results of Grid reports. I discourage achieving it by extending our frontend views as they are likely to change with upgrades that would break the customization.

As for List reports, they can be sorted by design.