Toad World® Forums

How do I create a report with multiple query and multiple DB connection


#1

Hi,

I’d like to create a unique report with different pivot grid, data chart from
differents queries. Each of these queries using 2 connection to DB.

Something like

SELECT * FROM MY CONNECTION1.SCHEMA.MY_TABLE

UNION

SELECT * FROM MY CONNECTION2.SCHEMA.MY_TABLE

Does anyone know how to do this ?

My major issue is still the use of differents queries in a same report. I can’t
find how to do this.

Thanks in advance,

Pierre Muckensturm

Service Ressources en Information Géographique

Direction des Moyens Généraux et Logistiques

REIMS Metropole

Place Max Rousseaux

51100 REIMS

FRANCE

03 26 35 38 03

N’imprimez ce courriel que si vous en avez l’utilité

image001.gif


#2

This is an area where we are doing many enhancement for the 3.0 release. Both in
respect to create a master detail report and also in regards to creating one
report with two completely unrelated sets of data.

/Henrik
image001.gif