Dynamic Sorting and PDF

[Arsenal]

Hi All,

Some of our reports have dynamic sorting (where the users click up and down arrows in the column headers) via Javascripts. But, the sorting is not passed on when the report is run in Excel or PDF.

I believe one way to get around this is to code the sorting via data items (2 per sortable column, I believe) and have a value prompt on the report body based off this data item, so the user can sort on the fly. Is there a simpler way? Is there a way where the Javscript sorting can be passed onto PDF/Excel?

Thanks