COGNOS下拉框（值提示）设置默认值

最新推荐文章于 2021-05-31 23:03:39 发布

逐安

最新推荐文章于 2021-05-31 23:03:39 发布

阅读量4k

点赞数 1

分类专栏： cognos 文章标签： cognos

cognos 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

------需求：

第一次打开报表就自动输入默认值。

------解决方案：
在report studio内增加以下javascript.

[@more@]

------详细方案英文原版：

Title:
Javascript: Changing first line and set default selection in value prompt for 8.3

Document#:
1038662.3

Updated:
Dec 01, 2008

Applies To:
Cognos 8 BI Report Studio 8.3

SRs:
1

Collection:
KB

--------------------------------------------------------------------------------

Note: This technique uses JavaScript against underlying report objects and methods in a IBM Cognos 8 BI report. For this reason, there is no guarantee that reports created using this technique will migrate or upgrade successfully to future versions without requiring modifications. Any such modifications are the responsibility of the report designer.

Description:

The following is a sample Javascript that allows for the first item in a value prompt to be selected and the descriptive text of the value prompt to be renamed in Cognos 8.3.

Environment:

C8.3 Report Studio

Root Cause:

Prompt objects in Cognos 8.3 are now dynamically named. This is why methods such as:

document.formWarpRequest._oLstChoicesprompt1[0].text = 'Select a Order Method...';

document.formWarpRequest._oLstChoicesprompt1.options[0].selected = true;

may no longer work because of the way in referencing the objects. The solution below is one way to access the objects.

Solution:

Surround the value prompt with HTML items in Report Studio, then add a third HTML item at the bottom of the prompt page with new script

Steps:

1. Add an HTML item to the left and right of the value prompt in the Report Studio

2. For the first HTML item (left) add '<span id = "A1">'

3. For the second HTML item (right) add '</span>'

4. Add an HTML item at the bottom of the prompt page next to "Run" button

5. Add the following script for the third HTML item:

<script type="text/javascript">

var theSpan = document.getElementById("A1");
var theSelect = theSpan.getElementsByTagName("select");
theSelect[0].options[2].selected=true; //This will make default value in prompt to be the first item after line, change the value '2' for other item
theSelect[0].options[0].text = '<PUT WHATEVER TEXT FOR VALUE PROMPT TITLE HERE>';

canSubmitPrompt();

</script>

6. The value "A1" can be anything you like. Run the Report. This works well when using prompt page.

7. Add the following script if you don't want to use a prompt page, and want to use auto-submit in the value prompt within the same page as the list/crosstab. In this case the third HTML item is put after the second HTML item that contained the close span. The first two HTML item will still need to be in the left and right of the value prompt object. The script looks like:

<script type="text/javascript">

function init()
{

var theSpan = document.getElementById("A1");
var theSelect = theSpan.getElementsByTagName("select");
theSelect[0].options[2].selected=true; //This will make default value in prompt to be the first item after line, change the value '2' for other item
theSelect[0].options[0].text = '<PUT WHATEVER TEXT FOR VALUE PROMPT TITLE HERE>';
promptButtonFinish();
}

</script>
<body onLoad=init()>

Related documents:

The following knowledge base articles describe additional methods of modifying the formWarpRequest to access the same objects in Cognos 8.3.

1013968 - Javascript: Changing the First Line of a Value Prompt or DropDownList prompt.

1036117 - JavaScript: Sample to automatically select first item in value prompt

Upgrading Javascript Applications to IBM Cognos 8.3/8.4
http://support.cognos.com/en/support/diagnostics/pdf/upgrading_javascript_applications.pdf

Keywords:

8.3 Script Value Prompt Title Default Selection Java