Adding Search Values in the Wizard

This topic describes how to add search values using the wizard.

To Add Search filter for rows, follow these steps:

1. Enter the search values for the different expand rows you want to add in the report.
2. Select the + icon to specify several expand rows in the wizard.
3. Enter the search values using SQL Smart Syntax. For example, if you selected ACCOUNT in question 10, you could as the first search filter for an expand row say that you want the application to expand all accounts starting with 3, then you would add search value 3* in the Question 11 field in the wizard.

Note: For more information about SQL Smart Syntax and how to enter your search values, see Syntax for SQL Smart.

If you select the same object as search column as the object in row 1, in this example ACCOUNT:

If you select a parent object to the object in row 1 as search column, in this example ACCOUNTGROUP which is a parent object to ACCOUNT: