Create Fields from Tables
You may create more than one field at a time, but all fields that are created together must be associated with a single table in the main query.
To create fields from tables in the main query
1. Click Insert, Data Fields, Fields from Table.
2. Click in the work area and drag the cursor to draw a field (rectangular area).
When you release the mouse button, the Reporter Table Selection dialog appears.
3. In the Tables list, select the table from which you want to select columns.
The Selected Table field displays the corresponding table name.
4. Click the toggle field to the right of the desired column in the Columns list.
An x should appear in the toggle field.
5. Click the Select/Unselect toggle field to select all items in the Column List.
6. In the Pattern field, enter a pattern-matching string (eight characters maximum) to restrict the names of columns to be listed; for example, d% would retrieve only column names beginning with “d”.
7. Click in the Create Fields Labels toggle field if you want labeled table columns.
8. Click Create.
The detail page of the report appears and the selected table fields are displayed.
9. Click File, Save to save your work.