Edit Worksheet dialog: Parameters tab

Use this tab to specify parameters for the current worksheet. This tab displays a list of existing parameters available to the worksheet. Use this tab to:

• display and hide existing worksheet parameters

• manage existing parameters

• create new parameters

For more information, see:

"What are parameters?"

"About using parameters"

View parameters for

Use this list to limit the parameters that are displayed in the list below. The default setting displays parameters for all items, which lists all parameters available to the current worksheet.

• To display a parameter in the current worksheet, select the check box beside the parameter that you want to display.

• To hide a parameter, clear the check box next to the parameter that you want to hide.

Description

This field displays the formula of the currently selected parameter.

New

Use this button to display the New parameter dialog (see "New Parameter dialog"). Use the New parameter dialog to create new parameters.

Edit

Use this button to display the Edit parameter dialog (see "Edit Parameter dialog"). Use the Edit parameter dialog to edit the currently selected parameter.

Delete

Use this button to permanently remove the selected parameter.

Notes:

• To remove a parameter from a worksheet without deleting the parameter, hide the parameter using the View parameters for drop down list.

• You are not allowed to delete parameters created for you by the Discoverer manager.

Move Up

Use this button to change the order of the parameter currently selected in the View parameters for list. Click this button to move the item one position up the list.

Move Down

Use this button to change the order of the parameter currently selected in the View parameters for list. Click this button to move the item one position down the list.

Options

Use this button to display the Options dialog. Use the Options dialog to specify:

• how Discoverer handles queries (see "Options dialog: Query Governor tab")

• how Discoverer formats worksheets (see "Options dialog: Sheet Format tabs")