Standard Parameters in Spreadsheet Server

Standard Parameters allow users full control over how the system interprets a parameter. When using Standard Parameters, the user must know various SQL rules for working with text fields, numeric values, lists, and ranges of values.

Note: Standard Parameters differ from Smart Parms. Smart Parms simplify query writing, by using standard rules for processing parameters (see Smart Parms Criteria Entry Rules and Smart Parms in Query Designer for more information).

Create a Parameter

1. In the Parameters grid, right-click, and, select Add Parameter.

2. Use the following table to enter data in the Parameters grid:

Field	Description
Parameter Name	Specify a unique name for the parameter.
Default Value	Specify the default value to be used for the parameter.
Type	Select a data type for the parameter, which will be saved in the query logic.
Sub Query Column	If required, click the ellipse button () to access the Select Sub Query Column panel, for selecting the column name to be used for matching to drill down panel column names, when determining whether the query is a valid subquery of the associated drill down.
Select Query	If required, click the down arrow, and, select the query to be used for listing the valid values of the parameter in Formula Builder

Insert a Parameter in a Criteria Field

1. In the Field List grid, click the ellipse button (), or, double-click the Criteria field associated with the desired field. The Expression Builder panel appears.

2. In the Expression Builder panel, from the Expression Elements section, click Parameters. The system displays a list of available parameters. From the parameter list, select the parameter to be used.

3. Right-click the parameter, and, select the desired menu option. The Smart Parm appears in the Enter an Expression to use in the query field. No supporting characters (=, <, >, etc.) are required.

4. Click OK. The Field List grid appears, with the parameter inserted in the selected criteria field.