Report Creation Using Several Tables
There are times when you want to use Report-Writer to produce a report from related information scattered across several tables that share one or more column definitions. You can do this by creating a temporary table or view based on multiple tables in the .setup section, using SQL statements. You can then drop the table or view, or update a status, in the .cleanup section of the same report.