Custom sorting

[vraju.springs@gmail.com]

Hi all I have a requirement . I have to sort products in custom order that is user required order it neithe assending of no descending. I have tried my best but unable to accomplish.Please help me

[wyconian]

Hi

Possibly the easiest way to do this is to have 2 columns, one sorted ascending, the other sorted descending.  You can then add render variables to the columns so you only render the one the user chooses.  You will need a prompt for the user to choose ascending or descending.

Bit of a fudge but the user thinks they are getting what they asked for :)

[pricter]

How to you want to order them?

Do you have a data item that specify the custom order?

[cognos79]

 you just need  to render. You dont need a data item for this ....
One column in ascending order and other in descending order .. so that it is rendered depending on the selection.

[blom0344]

Unfortunately custom sorts are not a strong point with WEBI BI reporting tools. With client tools this was normally possible as the data was fetched at random first and then an ordering could be applied.

With a limited set of values you can write a CASE statement assigning an index to values and sort on this dataitem