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

Specify Prompt Value

Started by woisau, 02 Jul 2007 07:41:40 AM

Previous topic - Next topic

woisau

Hello,

i want to specify prompt values for a check box but it doesnt work. I want to show different values what is in the database. When i define it like in the user guide the check box show me alle values, the values from the database and the values from the Static Choices. I think this works in v.8.1 but not in 8.2

any ideas


Specify Prompt Values
Provide your own values in a prompt
• to show something different from what is in the database
• to improve performance by not accessing the database
• to provide text for optional prompts, such as Select a value
• to restrict the number of values available
For example, you have a prompt in which users choose a country. For the database value United
States, you want USA to appear in the prompt.
Steps
1. Open the report that you want.
2. Click the prompt control that you want to modify.
3. In the Properties pane, double-click the Static Choices property.
4. Click the add button.
5. In the Use box, type the prompt value you want to add.
6. In the Display box, type the value that will appear in the prompt.
7. Click OK.
8. Repeat steps 4 to 7 to add other prompt values.
9. If you want to link a prompt value to a condition (p. 137), do the following:
• Click the Variable drop-down list and choose the variable you want to use or create your
own.
For information about creating variables, see "Adding Conditional Formatting to a
Report" (p. 137).
• Click the Value drop-down list and click one of the possible values for the variable.
• Click the static value you want to link to the variable and click the edit button.
• In the Display box, type the value that you want to appear in the prompt for that
particular value of the variable.
• Repeat this procedure for each additional value.
10. Click OK.

larsonr

Are you trying to use items that don't exist in the database or just wanting to rename the ones coming out of the database?

woisau

Hi,

i want to rename items out of the database

e.g. Datatbase Item 'O' and 'F'
show in the checkbox as 'Offen' and 'Fakturiert'



larsonr

Create a query that has two data items.  The first query item is the database item.  The second query item will be a case statement on query item 1. 

CASE QueryItem1
WHEN 'O' THEN 'Often'
WHEN ....
END

Call this new item QueryItemDisplayName or something.

In your prompt, there should be options to have a display value and a use value.  Set the display value to the DisplayName query item and the use value to the database object.  This should resolve your issue.  If not, please let me know.

woisau

thx,

the problem is resolved