To create a new query, proceed as follows:

1. Call the component Maintain Queries.
2. Choose the user group to which you want to assign the new query.
3. Enter the desired query name.

Query names can be up to 14 characters long and should not already exist in the user group.

4. Choose Create.

You then see a list of the InfoSets assigned to your current user group.

5. To select the InfoSet you require, place the cursor on the InfoSet and choose Select.

All the examples in this chapter are based on a flight reservation system and evaluate flight bookings. You should therefore choose the InfoSet FLBU.

You may now begin to define your report. The system takes you through several screens. Four different screen sequences are possible:

• Field selection (including assignment of title and list format)

• Basic list (define layout of basic list)

• Statistics (define layout of statistics)

• Ranked list (define layout of ranked lists).

Within each of these screen sequences, you have the following navigation options:

• Use the Next screen and Previous screen functions.

• Use the functions in the Goto menu to access individual screens directly.

• Use the Back function to return

• to the first screen in the sequence, if you are not already on this screen or
• to another screen sequence, if you are on the first screen in the sequence.

If you want to switch from one screen sequence to another (for example, go from one of the basic list screens to the field selection), you can use the appropriate function in the Goto menu. The following screen shows the most important navigation options.

Within a query, you can define one basic list, up to 9 statistics and up to 9 ranked lists. These different list types may be combined in any permutation you like. You can also extend existing queries by adding more sub-lists. Unless you have specified otherwise, you see the basic list first, followed by the statistics and finally the ranked lists when you execute a query.