Eclipse Community Forums: BIRT » Sort Column on the Fly (Urgent, please help!!)

Home » Archived » BIRT » Sort Column on the Fly (Urgent, please help!!)

Sort Column on the Fly (Urgent, please help!!) [message #118237]

Thu, 26 January 2006 19:08

Eclipse User

Is there any way to build the sorting mechanism on the fly using the
expression builder or pass the order by parameter to the dataset? For
example, I have mutiple columns and I need to sort each column by clicking
on the column header. Your help is greatly appreciated. Thank you.

Re: Sort Column on the Fly (Urgent, please help!!) [message #147663 is a reply to message #118237]

Thu, 23 March 2006 18:14

Eclipse User

Originally posted by: brandon.shannon.s1.com

I've done sorting based off of a parameter.

Create a 'paramSortField' parameter, and a 'paramSortDir'.

In the 'beforeOpen' event of your dataset, do something like:

if (params["paramSortField"] != null)
{

this.queryText += " order by " + params["paramSortField"] + " " +
params["paramSortDir"];

}

else

{

this.queryText += " order by our_reference asc";

}

Now, you can pass in your sort field and direction. I would also like to
do hyper-links on column headers...maybe someday soon.

Brandon

"Eric Yang" <sirericyang@gmail.com> wrote in message
news:030b9e5743ffd2c5148df18c1990360c$1@www.eclipse.org...
> Is there any way to build the sorting mechanism on the fly using the
> expression builder or pass the order by parameter to the dataset? For
> example, I have mutiple columns and I need to sort each column by clicking
> on the column header. Your help is greatly appreciated. Thank you.
>

Previous Topic:	Getting Parameter Information
Next Topic:	Program too complex: too big jump offset

Goto Forum:

-=] Back to Top [=-

Current Time: Wed Jun 11 19:24:58 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter