Language:


Adding a Search - Adding a Second Search to the Specification Window

A report can benefit from a second search that can be used on its own or in combination with the first. For example, it might be useful to be able to search for the Customers with Contact Numbers in a specified range that also belong to a specified Customer Category. Follow these steps:
  1. Return to the Report Definition record and go to the 'Data' card.

  2. Click on the line in the report display area marked "Register: Contacts..." to specify that the search is to be carried out in the Contact register, and then click the [Selection] button. Complete the 'Selection' dialogue box as described here and illustrated below:

    In this example, a new variable named vsCustNo will be placed in the specification window, linked to the Code field ("Code" is the internal name for the Contact Number field in the Contact register). If the person producing the report enters a Contact Number or range of Numbers in the vsCustNo variable, there will be a search for Contacts whose Contact Number matches what was typed. Remember that the automatic search for Contacts where CUType is 1 will remove any Contacts in the range that are not Customers from the results.

    The default figure in the v field places the new vsCustNo variable 20 pixels below the existing vsCategory variable.

  1. The new variable and search appears on a separate "Selection:" line in the report display area as shown below:

  1. Change to the 'Input' card. This shows you what the specification window will look like:

    If the new variable is not quite correct (e.g. it is not in the correct position in the specification window, or there is a spelling mistake in the Label), you can change it by double-clicking the variable on the 'Input' card or by double-clicking the "Selection:" line on the 'Data' card.

    The white area represents the width of the specification window: if you need to change this, use the Spec Window Width field on the 'Settings' card.

Please click the links below for more details about: