Add Tables to a Report Manually

If you require a high degree of control over the tables used in a complex report, you can manually add them to the report instead of having the tables added automatically.

Before you start

To ensure report queries are efficient, manually adding tables to a report should be performed only by individuals with a thorough understanding of SQL queries.

Here's what to do

1. Delete all columns and filters from an existing report, or start with a report with no columns.
2. Click Tables on the Home tab.
   The Data Set window opens.
3. Click Select Table.
   A list of all tables displays.
4. Select the table you want from the list.
5. Click OK to add the table to the report.
6. To join additional tables to the table you added, right-click the table you added, select Join To, and select the table to join.
7. Repeat step 6 for each table you want to add.