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
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 :)
How to you want to order them?
Do you have a data item that specify the custom order?
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.
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