Use the Source File tab to provide the name of the source file for the report and identify tables in the file from which to compile the report. The Source File tab is available if you select File as the Report Type on the General tab.

Select (Local) for a file that resides on the workstation or click the down arrow to select the server on which the file resides.
Enter the complete path and file name for the file containing the data for the report. Type the name, click the Browse button to select the file from a directory, or click the Retrieve button to select the last file you created. To browse the contents of the source file, right-click the file name and select Browse from the shortcut menu.
A list of tables in the source file. The label varies according to the Show joins setting on the Archive Details tab. You can create a report that lists the contents of selected tables or a report that shows a segment of joined rows in the tables. To create a report that lists the contents of selected tables, you must clear the Show joins check box on the Archive Details tab.
To create a report showing joined segments of archived data, you must select the Show joins check box on the Archive Details tab.
When you select the Show joins check box on the Archive Details tab, you must select a start table from the list of tables on the Source Table tab. You can then use the Edit Joins dialog to join related tables, beginning with the start table. You can join data from other related tables in the source file, provide selection criteria, and format the report to start a new page for each segment of joined data, beginning with the parent row. Click to display the Edit Joins dialog.

Select a table name in the Joined Tables tree to display the names of related tables in Related Tables. Use shortcut menu commands to edit selection criteria for the selected table, precisely defining the segment of archived data in the report, to assign each selected row of the table to a new report page, or to remove a join.
Double-click a name in Related Tables to join the table to the table selected in Joined Tables tree. Alternately, you can right-click the table name and select Join Table from the shortcut menu. If more than one relationship between a pair of tables exists, you are prompted to select the relationship to use.
You can define selection criteria for any table listed in the Joined Tables tree on the Edit Joins dialog. The selection criteria apply to the table in all archive files processed by the report request. To define selection criteria, right-click a table name in the Joined Tables tree and select Edit Selection Criteria from the shortcut menu. The Report Selection Criteria dialog is opened with the selected table name displayed in Table .

The dialog has two tabs. Use the Column Criteria tab to define selection criteria for one or more columns in the selected table, or the SQL tab to define an SQL WHERE clause for the table. For further information, see Column Criteria Tab
For complex selection criteria that cannot be defined on the Column Criteria tab, use the SQL tab to create an SQL WHERE clause. For example, to select the desired rows from a table, you may need a combination of AND and OR logical operators. For further information, see SQL tab.