Remove Dotted Line From Value Prompt In IBM Cognos10 Report Studio.

Remove Dotted Line From Value Prompt.

In this paper we will discuss how we remove dotted line from value prompt. Cognos report studio support many built-in functionality that helps in reporting. But for some functionality we can use code of HTML (Hyper Text Markup Language) and JS (Java Script). That supports the cognos very well.

Steps :

·         Create a list report.

·         Select the value prompt from tool box.

·         Drag it on to the work area.

·         Write the name of prompt click next.

·         Select package item from available items.

·         Select the operator that you want to use like =,>, <, in, not in etc.

·         Choose the value that you want to display from available package items.

·         Click finish.

·         Drag HTML Item from tool box.

·         Double click on it and write the code using java script and HTML.

·         Code will be :

/* 

<script language="javascript">

// for removing elements in the prompt according to their indexes (position)

var list=document.getElementsByTagName("SELECT")[0];

list.remove(1);

list.remove(0);

list.removeAttribute("hasLabel");

list.options[0].selected = true;

canSubmitPrompt();

</script>          

*/

·         Remove ‘/*’ from the beginning and end of the code.

·         If you want to remove the element that is at index [0] then add  list.remove(0);

·         At position [0] there will be a name of column.

·         For removing the element from   position 2 add list.remove (2); etc.

·         list.remove(1); // for removing dotted line because it is at position 1.

·         list.remove(0); // for removing column name because it is at position 0.

·         Run the report.

For Further visit: http://www.segmentbi.com/