- IBM Cognos 10 Report Studio Cookbook（Second Edition）
- Ahmed Lashin Abhishek Sanghani
- 332字
- 2021-08-06 17:03:28
Changing the title of the value prompt
In the previous example, the first line of the value prompt shows the data item name, that is, Month key (ship date) as shown in the following screenshot:
The business owners want to change this to a more generic and user-friendly text.
Getting ready
We will use the report generated in the previous recipe.
How to do it...
We need to add a line to the JavaScript from the previous recipe to change the text of first option (index 0). To do this perform the following steps:
- Open the prompt page of the report created in the previous recipe.
- Double-click on the HTML item that contains the JavaScript.
- Replace the code with the following:
<script> var theSpan = document.getElementById("A1"); var a = theSpan.getElementsByTagName("select"); for( var i = a.length-1; i >= 0; i-- ) { var prompts = a[i]; if( prompts.id.match(/PRMT_SV_/)) { prompts.selectedIndex = 3; prompts.options[0].text = 'Choose Shipment Month'; /* This is the new line added to script */ } canSubmitPrompt(); } </script> - Run the report to test it as shown in the following screenshot:
How it works...
By default, the first line of a value prompt is the name of the data item. If you define the data item expression within brackets, that is, ([Sales (query)].[Time (ship date)].[Month key (ship date)]) in this example, then the first line of the value prompt is populated by the parameter name.
However, there is no property within Report Studio that would allow us to put a custom title. Hence, we are using JavaScript. We already know how to capture the prompt control using the GetElementsbyTagName function. Once it is captured, we can manipulate the values. We change the text property of the options[0] element to update the first line of the prompt.
There's more...
You can also use the REMOVE() function to remove particular lines of a value prompt. It is often useful to remove the first two lines (title and separator) using the following statements:
Prompts.remove(0);
Prompts.remove(1);
Prompts.removeAttribute("hasLabel");
- Mobile Web Performance Optimization
- Pandas Cookbook
- Practical DevOps
- 機械工程師Python編程：入門、實戰與進階
- KnockoutJS Starter
- SQL經典實例（第2版）
- C語言程序設計教程
- Learning AngularJS for .NET Developers
- Clojure for Machine Learning
- 編程可以很簡單
- Python：Deeper Insights into Machine Learning
- Python編程：從入門到實踐（第3版）
- Java 從入門到項目實踐（超值版）
- R語言：邁向大數據之路
- Learning GraphQL and Relay