Selecting Fields

  To select the columns that will make up the query fields:

1. Select the desired columns.

   • Drag a column from Tables and Columns to Query Fields.

   • Select a column and click .

   • Double-click a column.

     To select all of the columns in a table, select the table using one of the methods described above. To remove a column from Query Fields, click the column and click the left arrow. (To select more than one column to delete, hold down the [Ctrl] key and click the desired columns.)

2. Use to define the column order in the default report layout.

   The default layout initially appears when you format a report in the Layout window. The order in which the database columns appear on the Query Builder - Fields page is the order in which the columns will appear in the default report layout. You can change the column order when formatting a report in the layout if desired.