Specify Prompt Values

You can provide your own values in a prompt instead of the default values that come from the database.

You can specify your own prompt values to

  • show something different from what is in the database
  • improve performance by not accessing the database
  • provide text for optional prompts, such as Select a value
  • restrict the number of values available

For example, you have a prompt in which users choose a country or region. For the database value United States, you want USA to appear in the prompt.

Tip: The Rolling and Moving Averages interactive sample report includes a value prompt.


  1. Click the prompt control.
  2. In the Properties pane, double-click the Static Choices property.
  3. Click the add button add icon.
  4. In the Use box, type the prompt value to add.
  5. In the Display box, type the value that will appear in the prompt.
  6. Repeat steps 3 to 5 to add other prompt values.
  7. To link a prompt value to a condition, do the following:
    • In the Variable box, choose the variable to use or create your own.

      For information about creating variables, see Add a variable from the condition explorer.

    • In the Value box, click one of the possible values for the variable.
    • Click the static value to link to the variable and click the edit button edit icon.
    • In the Display box, type the value to appear in the prompt.
    • Repeat this procedure for each additional value.