If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

onload page when launching report

Started by Mounika_LP, 03 Feb 2015 11:35:15 PM

Previous topic - Next topic

Mounika_LP

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