The default value for the first item in a drop down list is the name of the database field. I need to change it to a more user friendly name. How do I change the value?
下拉列表中第一个项的默认值是数据库字段的名称。我需要将其更改为更友好的用户名。我该如何更改价值?
4 个解决方案
#1
5
add a HTML Item onto the prompt page and add the following as an HTML item:
在提示页面上添加HTML项目并将以下内容添加为HTML项目:
Example: <script> document.formWarpRequest._oLstChoicesMyList[0].text = '--SELECT A CITY--'; </script>
示例:
Replace 'MyList' with the name of the component.
将“MyList”替换为组件的名称。
from: link text
来自:链接文字
#2
4
In Cognos 10, you can specify prompt text of your choice in Report Studio.
在Cognos 10中,您可以在Report Studio中指定所选的提示文本。
- Select the value prompt
- In Properties pane, under 'Prompt Text' section, the 'Header Text' property will be set to Automatic. Click the ellipsis button next to it and Header Text Dialogue opens.
- Select 'Specified Text' choice. Click ellipsis.
- Provide the text of your choice and click ok.
- Run the report and you will see text that you provided will appear as first item in the drop down list.
选择值提示
在“属性”窗格的“提示文本”部分下,“标题文本”属性将设置为“自动”。单击旁边的省略号按钮,打开标题文本对话框。
选择“指定文本”选项。单击省略号。
提供您选择的文本,然后单击“确定”。
运行报告,您将看到您提供的文本将显示为下拉列表中的第一项。
I have provided a Screen shot for a better understanding.
我提供了一个屏幕截图,以便更好地理解。
#3
2
You have a couple of options. First, you can rename the data item's name from database field name to a more friendly name in the Framework Manager metadata.
你有几个选择。首先,您可以将数据项名称从数据库字段名称重命名为Framework Manager元数据中更友好的名称。
Second, you can rename the item in Report Studio. However, if you do this you will notice that it is still using the database name. You actually need to perform a calculation in the item expression for it to use your name instead of the default name. So say you are pulling in the string field [Namespace].[Unfriendly Name] and you named your report data item "Friendly Name." The top selection will still read "Unfriendly Name." However, if you replace the data item with the following:
其次,您可以在Report Studio中重命名该项目。但是,如果这样做,您会注意到它仍在使用数据库名称。实际上,您需要在项表达式中执行计算,以便使用您的名称而不是默认名称。因此,假设您正在拉入字符串字段[Namespace]。[Unfriendly Name]并将您的报告数据项命名为“Friendly Name”。最佳选择仍然是“不友好的名字”。但是,如果使用以下内容替换数据项:
[Namespace].[Unfriendly Name] || ''
[命名空间]。[不友好的名字] || “”
It will see that there is a calculation involved and use your friendly name. In the case of a number field you have to add zero instead of concatenating ''.
它会看到涉及计算并使用您的友好名称。在数字字段的情况下,您必须添加零而不是连接''。
This is also the case with report column headers (which you can replace with text instead of using this calculation method).
报告列标题也是如此(您可以使用文本替换而不是使用此计算方法)。
Convoluted? Yes.
#4
1
Within the dataitem in the query.. you could do a ..
在查询中的dataitem中..你可以做一个..
IF ( [dataitemA] = 'some text' ) THEN ( 'new text' ) ELSE ( [dataitemA] )
IF([dataitemA] ='some text')THEN('new text')ELSE([dataitemA])
i try to avoid using javascript and html items becuase they dont generally work in pdf or excel outputs.
我尽量避免使用javascript和html项目,因为他们通常不使用pdf或excel输出。
just a thought..
只是一个想法..
cheers!
#1
5
add a HTML Item onto the prompt page and add the following as an HTML item:
在提示页面上添加HTML项目并将以下内容添加为HTML项目:
Example: <script> document.formWarpRequest._oLstChoicesMyList[0].text = '--SELECT A CITY--'; </script>
示例:
Replace 'MyList' with the name of the component.
将“MyList”替换为组件的名称。
from: link text
来自:链接文字
#2
4
In Cognos 10, you can specify prompt text of your choice in Report Studio.
在Cognos 10中,您可以在Report Studio中指定所选的提示文本。
- Select the value prompt
- In Properties pane, under 'Prompt Text' section, the 'Header Text' property will be set to Automatic. Click the ellipsis button next to it and Header Text Dialogue opens.
- Select 'Specified Text' choice. Click ellipsis.
- Provide the text of your choice and click ok.
- Run the report and you will see text that you provided will appear as first item in the drop down list.
选择值提示
在“属性”窗格的“提示文本”部分下,“标题文本”属性将设置为“自动”。单击旁边的省略号按钮,打开标题文本对话框。
选择“指定文本”选项。单击省略号。
提供您选择的文本,然后单击“确定”。
运行报告,您将看到您提供的文本将显示为下拉列表中的第一项。
I have provided a Screen shot for a better understanding.
我提供了一个屏幕截图,以便更好地理解。
#3
2
You have a couple of options. First, you can rename the data item's name from database field name to a more friendly name in the Framework Manager metadata.
你有几个选择。首先,您可以将数据项名称从数据库字段名称重命名为Framework Manager元数据中更友好的名称。
Second, you can rename the item in Report Studio. However, if you do this you will notice that it is still using the database name. You actually need to perform a calculation in the item expression for it to use your name instead of the default name. So say you are pulling in the string field [Namespace].[Unfriendly Name] and you named your report data item "Friendly Name." The top selection will still read "Unfriendly Name." However, if you replace the data item with the following:
其次,您可以在Report Studio中重命名该项目。但是,如果这样做,您会注意到它仍在使用数据库名称。实际上,您需要在项表达式中执行计算,以便使用您的名称而不是默认名称。因此,假设您正在拉入字符串字段[Namespace]。[Unfriendly Name]并将您的报告数据项命名为“Friendly Name”。最佳选择仍然是“不友好的名字”。但是,如果使用以下内容替换数据项:
[Namespace].[Unfriendly Name] || ''
[命名空间]。[不友好的名字] || “”
It will see that there is a calculation involved and use your friendly name. In the case of a number field you have to add zero instead of concatenating ''.
它会看到涉及计算并使用您的友好名称。在数字字段的情况下,您必须添加零而不是连接''。
This is also the case with report column headers (which you can replace with text instead of using this calculation method).
报告列标题也是如此(您可以使用文本替换而不是使用此计算方法)。
Convoluted? Yes.
#4
1
Within the dataitem in the query.. you could do a ..
在查询中的dataitem中..你可以做一个..
IF ( [dataitemA] = 'some text' ) THEN ( 'new text' ) ELSE ( [dataitemA] )
IF([dataitemA] ='some text')THEN('new text')ELSE([dataitemA])
i try to avoid using javascript and html items becuase they dont generally work in pdf or excel outputs.
我尽量避免使用javascript和html项目,因为他们通常不使用pdf或excel输出。
just a thought..
只是一个想法..
cheers!