i am using 10.2 version and relation DB
i am given security When launching my report depending acess employee only display other employee display message"U don't have access please contact u r admin"
i am tryed this way:
1.From DB we have Status values say 1 and 0 .If status=1 employee acess, and status= 0 employee not acess.
2.I created value prompt
3.Then Created a String variable.
The Condition I used are as follows.
CASE
WHEN paramDisplayValues('promptparamname')=1 THEN 'yes'
WHEN paramDisplayValues('promptparamname')=0 THEN 'NO'
END
4.Then selected Render variable as 'NO' ."U don't have access please contact u r admin"
And remain table "YES".
5. For removing First 2 lines of Value Prompt I have used the following JS to achieve.
<script language="javascript">
var f = getFormWarpRequest();
var list = f._oLstChoicesUSERLOGIN;
list.remove(1);
list.remove(0);
list.removeAttribute("hasLabel");
</script>
6.Manually it working when selecting 1 or 0 but when removing First 2 lines of Value Prompt and Value Prompt visible=no page not loading.
anybody help me how to achieve this one
thanks
Mounika