Before you can create a report you must select the database tables that contain the data for your report. Click the Tables tab, shown below, to choose which tables to include in your query.
|
The radio buttons in the Table Types section, define the database tables that are displayed in the Available Tables: list. The radio buttons are:
• User Tables
• Accessible Tables
• System Tables
When User Tables is selected, the Available Tables: list displays the database tables assigned to the user you have logged in as.
When Accessible Tables is selected, the Available Tables: list includes the tables displayed when User Tables is selected plus any tables assigned to other users, providing you have been granted access rights to these tables.
When System Tables is selected, the Available Tables: list includes the tables displayed when Accessible Tables is selected plus any tables created by the database system itself.
The format of the tables in the Available Tables list is:
database_name.table_name
For example, if the database is named reporter and the table is named REPORTER_STATUS the entry is displayed as reporter.REPORTER_STATUS. Each table selected is included in your query.
Note:
Temporary tables that you have created using the Temp Table tab appear in the Available Tables: list. The temporary table name is always preceded by the # character.
You should select only those tables that you intend to use in your report. This prevents the Report Designer from returning too much data and slowing down your search.
To add a table, select the table name and click the Add> button. The table name is copied to the Selected Tables: list.
To remove a table, select the table name in the Selected Tables: list and click the <Remove button.
You can also double-click a table name to add or remove the table.