Hi All,

I have a field "Hours" and its has values from 1-24, it gives the hour in which an incident happened. The user wants to enter any value between 1-24 in the parameter and see the incidents for that period. For example if he/she enters the value "06-09" then they must see all the incidents between 6am and 9am.

Secondly i have a field "RTDIRNTYMEAS" with the following set of values :

94 w m 35.0
80 w m 7.7
65 s m 33.2
465 e r 22.2

From these records i have to extract the direction "e,w,n,s" and i used the following calculation :

ltrim(substr(t1.RTDIRNTYMEAS,4,2))
but when i used the above calculation as a page item i'm getting additional value for each, for example in the page item drop down i'm getting e,e,w,w,n,n,s,s,all. How can i get just one of each? please need help or advice.

Thanks