To connect a source property to a parameter

You can connect an object such as a list box or tree to a parameterized SQL statement, as follows:

  1. Insert an object (for example, a grid or chart object) into your display to show the values from the SQL statement. The SQL statement you use must have parameters.

  2. Select the SQL statement as the data source for the grid or chart you are adding.

  3. Insert a list box, right-click it and select Link Property To. The Parameter Connections dialog box appears.

  4. Select Selected Item as the source.

  5. Click the Add button to add a new connection. The Select a Parameter dialog box appears.

  6. On the Select a Parameter dialog box, select the parameter you want to connect to.

  7. Click OK to make the connection and return to the Parameter Connections dialog box.

  8. Click OK to save your changes.