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
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.
Thanks BigChris
got it with your solution
Thanks again
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
Oh. Double posted, and I answered in the wrong one. I be sad now. :'(
Quote from: hespora on 28 Nov 2016 07:01:02 AM
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!
Oh my... if anything, that was not an attempt an point wh***ing. :-\
I didn't think it was. I just took the opportunity to say thank you for all the great help and advice you provide.
:)