You can add the results of one query to the results of another query in an Interactive Reporting document file by using local joins. Rows from the data sources are joined in the Results section.
No aggregation can be applied to local result tables and the local results data set cannot be processed to a table. |
For example, you might want to see budget figures drawn from MS SQL server and sales figure drawn from an Oracle database combined in one Results set.
Local joins are memory and CPU intensive operations. When using this feature, please limit the local joins by using a moderate number of rows. |
The following sections explain how to work with local joins: