Edit Parameter dialog

Use this dialog to change the way that the currently selected parameter item behaves. For example, you might want to changes the parameter's name, description, prompt, or default values.

For more information, see:

"What are parameters?"

"About using parameters"

What do you want to name this parameter?

Use this field to enter a descriptive name for the parameter. This name is displayed in the parameter list on the Parameter dialog. If you leave this box blank, Discoverer creates a default name for you.

This parameter is based on the item named

This read-only box displays the name of the item on which the parameter is based. If you want to create a parameter based on a different item, create a new parameter.

What prompt do you want to show other users?

Use this field to enter a question or instruction that describes the parameter value that the user should enter. This prompt is displayed on the Edit Parameter Value dialog. For example, 'What year do you want to look at?', or 'Please choose a region'. If you leave this box blank, Discoverer creates a default prompt for you.

What description do you want to show other users?

Use this field to enter a brief description of the parameter that tells users what the parameter is used for. This description is displayed on the parameter list on the Parameters dialog, and on the Edit Parameter Values dialog.

What default value do you want to give this parameter?

Use this field to enter the most commonly used parameter value as default on the Edit Parameter Values dialog. If users do not enter a value, the value that you enter here is used.

Let other users select multiple values?

Use this check box if you want users to be able to choose more than one value to match against the item.

What is the value of this parameter if it is used in more than one sheet?

• Click the Allow only one value for all Sheets radio button to make the parameter value apply to all worksheets in the workbook.

• Click the Allow a different value in each Sheet radio button to make the parameter value apply to the current worksheet only.

Format Data

Use this button to display the "Format Data dialog", where you change how the item values look on the worksheet.

Format Heading

Use this button to display the "Format heading dialog", where you change how the item headings look on the worksheet.