You can create reports that use temporary tables, either as the main table or as a secondary table. Like other tables, temporary tables are defined in Dexterity using the Table Definition. Refer to Tables for more information about creating temporary tables.
You can treat temporary tables the same as any other Dexterity tables when creating reports. Their table names are included in the scrolling window from which you choose your report’s main table in the Report Definition window. They’re also included, when appropriate, in the Report Tables window from which you select secondary tables.
Temporary tables are useful for reports that need to access data from multiple tables with one-to-many relationships with other report tables. You can create a temporary table specifically for use by a report, and use sanScript to fill that table with the information you need. You can then access the temporary table to retrieve the desired data for your report.
One thing differentiates reports that use temporary tables from other reports created using the Report Writer. Reports that use temporary tables can’t be run in tools mode using the Print button on the Reports window. They must be run in either test mode or with the runtime engine, since, as their name implies, temporary tables are temporary and don’t exist outside of the runtime or test mode environments.