New Parameter dialog

Use this dialog to create a new parameter item. For example, you might want to enable Discoverer users to choose how they filter worksheet data when a worksheet is opened.

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

Use this pull down list to specify which item you want to base the parameter on. The list contains items available to the worksheet. For example, if you want to filter a worksheet on calendar month, you might choose Month here.

What prompt do you want to show other users?

Use this field to enter a question or instruction that tells users what information they need to enter when choosing a parameter value. 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 in 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 cascade across 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.