Enabling Partial String Searches

In this step we add a feature to the CustomerListByState report that enables partial string searches (for example, searching for all customers with a name that starts with the letter C).

To enable partial string searches:

  1. Select the Layout tab, then select Report > Report Parameters from the SampleReports menu.

The Report Parameters dialog box displays.

 

 

  1. Click Add, then type a name for the new parameter in the Name textbox (in this tutorial, the parameter is named Name).

  2. Define the properties for the new parameter from the Property section of the dialog box, and then click OK.

  3. Select the Data tab.

  4. Open the Generic Query Designer and update the query string as appropriate.

  5. Select the Preview tab from the report design environment.

Note that the report now prompts for the customer’s state and name. Entering C] lists all customers whose name starts with the letter C from the specified state.