1. You can use the Data Environment of the report. Here you can set the order of the tables, the relation between tables, everything.

2. Or before executing the report with SQL select command you select the data needed to the report into the cursor and then start the report.

Iván