Is it possible to to have named query that gets data from more than 1 datasource/gateway database? Do I just need to explicitly specify the datasource name in front of the table name?
If this is not possible, what the best way to combine data like this onto a single report?