Welcome and thank you for joining our new OpenText forum. Your questions, responses, best practices, and tips shared with other members will help make this channel vibrant. We're glad you're joining us and look forward to collaborating with you online.

Check out the Getting Started With OpenText Forums for tips on personalizing your experience.

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.