Sort column as per user selection

[krunal]

Hi Guys,

report requirement  is

on report page we have value prompt with dropdown list

In that we have 3 values Job, Deptno and Ename

we also have list report with Column Job,Deptno and Ename

now when user selects value Job in value prompt data should be sort as per Job
and if user selects value Deptno in value prompt data should be sort as per column Deptno and same with Ename as wel.

Sorry for my poor English

Thanks in advance

[BigChris]

The simplest way is to have three lists in your report, list 1 sorted on Job, list 2 sorted on Deptno etc. Then create three render variables and only show the list that corresponds to the option chosen.

[krunal]

Thanks BigChris 

got it with your solution

Thanks again

[Lynn]

Here is a very simple approach that eliminates the need to maintain multiple lists and render variables.

http://www.cognoise.com/index.php/topic,13317.msg42069.html#msg42069

[hespora]

Oh. Double posted, and I answered in the wrong one. I be sad now. :'(

[Lynn]

Oh. Double posted, and I answered in the wrong one. I be sad now. :'(

Don't be sad!  ;D

I gave you an applaud if that helps!

[hespora]

Oh my... if anything, that was not an attempt an point wh***ing.  :-\

[Lynn]

I didn't think it was. I just took the opportunity to say thank you for all the great help and advice you provide.
:)