Dynamic Column Sorting

SailRCGSailRCG Junior Member
edited June 26, 2013 in DevShare Downloads
I regularly receive requests to provide column sorting functionality in report designs. To do this I simply create a dynamic 'order by' clause controlled by some hidden parameters and column hyperlinks. Admittedly, I use this method on relatively simple and fast queries because the solution requires re-execution for every sort selection.

Here's how it's done: (after you've created a report with a table )



1 - Create a Boolean parameter for each column to be sorted.



2 - Add script to the beforeOpen of the Data Set.



3 - Create hyperlinks for each column corresponding to the parameters you created in step 1.



That's all there is to it.



I've attached an example built on the Classic Models database for your enjoyment.
Sign In or Register to comment.