Use this step of the wizard to specify the columns that should be included in your query. By default, this step is displayed in "Single table view" which means that only the columns from the table you selected in the Select Table step will be shown. The "Multiple table view" allows you to add other tables and their columns to your query.
Single Table View
When in this view, the list of columns from your table are displayed as a simple list of check boxes.
The Columns in table-name column displays the caption that will be used for the column. The Internal Name column displays the name of the column in the database. Depending on the type of database, this may be a somewhat cryptic name.
Check the box for each column that you wish to include in your query. Until the first column is selected, the Preview Pane will display all columns. Once you begin selecting columns, only the columns that you have selected will appear in the Preview Pane.
You may sort the list of columns by clicking any column header. Clicking a column header a second time reverses the sort direction. Clicking it a third time will return the column list to context order. This is the order in which the columns naturally appear in the database table (from left to right).
Multiple Table View
Click Add more tables to switch to this view. When in this view, a tree is displayed showing all possible tables with their columns listed underneath. In this view, you have access to all of the tables and views in your database.
Click this drop-down to select Tables and Queries, Tables, Queries, System Tables, and Selected Tables. The list will be filtered accordingly.or Ctrl+F
Displays the Find window which allows you to enter some text to locate in the list. The first matching item in the list will be selected. Press F3 to repeat the same search and find the next matching item.
Table and Column List
The list of tables and columns is displayed as a tree with the tables are at the top-most level. Click the [+] box next to a table name to display its columns. If you only intend to add the table so that its columns can be included in conditions (on the next step), you only need to check the box for the table and you do not need to check any columns. Check the box for columns that you wish to display in the results of your query. Columns will be added to the query in the order selected. You may also drag and drop columns onto the Preview Pane in order to place them in the desired order.
When you add a new table to your query (either by checking its box or checking the box of one of its columns), Liberty Reports will check to see if there are any predefined relationships between the already-selected tables and the new table you are adding. A table relationship defines how the rows in your query relate to the rows in the table being added. One of three things will happen when adding a table:
- If a there is a known relationship between the new table and the tables in your query, the table will be automatically added to your query with no additional prompts.
- If the new table could be related to the other tables in your query in more than one way, the Table Relationship Wizard will be displayed asking you to select the relationship that should be used.
- If there are no known relationships between the new table and the tables in your query, the Table Relationship Wizard will be displayed allowing you to identify how the new table is related.
This list shows a list of distinct values from the column that is currently selected in the column list. This preview allows you to see the types of values you can expect if you choose to include the column in your query.
The Preview Pane displays rows from the selected table or view so that you can confirm that it contains the expected data.