6.2.5 Using a Parameter in a Condition
You can use a variable or parameter as the test value in a filter condition. By default, the user of the Worksheet (including users of linked Viewsheets and reports) will be prompted at runtime to enter the value of the parameter.
The value of the variable can also be supplied from the following sources:
• Viewsheet input component. (See Passing Inputs to an Embedded Table or Variable in Dashboard Design.)
• User session data. (See SRPrincipal Properties in Integration.)
To use a variable or parameter in a filter condition, follow these steps:
1. Open the Worksheet containing the table you want to filter.
2. (Optional) To reference a a variable asset in the condition, first create the Variable asset, or drag an existing Variable from the asset tree to an empty cell in the Worksheet. (See Defining a Variable for more information.)

3. Click the 'Condition' button on the title bar of the table you wish to filter. This opens the 'Condition' dialog box.
4. Open the edit field in either the 'Simple Condition' mode (click the 'More' button) or 'Advanced Condition' mode (click the pre-aggregate or post-aggregate 'Edit' button).
5. To use a variable in the condition, select 'Variable' from the rightmost popup menu. This opens a blank Combo Box on the right side of the condition.

In the Combo Box, do one of the following:
a. Select an existing Worksheet Variable from the menu.
b. Type the name of a new parameter.
c. Type the name of a Viewsheet input component.

6. To use session data in the condition, select 'Session Data' from the rightmost popup menu. This opens a menu on the right side of the condition.

Note that the adjacent menu automatically chooses the 'equal to' or 'one of' operator to match your selection.
In the menu, choose one of 'User', 'Roles', or 'Groups'. These parameters return information about the user who is currently accessing the Worksheet; respectively, the user name, the array of roles to which the user belongs, and the array of groups to which the user belongs.

7. Define the rest of the condition as described earlier.
The default prompting for Variables and parameters is the same. However, Variables provide additional control over the interface (radio button, menu, etc.) and the set of choices presented to the user.
See Also
Filtering, for details on specifying filtering conditions.
Defining a Variable, for more information on defining a Variable.
| << 6.2.4 Filtering Operators | © 1996-2013 InetSoft Technology Corporation (v11.5) | 6.2.6 Using a Field in a Condition >> |