# Set Reports Manager on multiple databases ?

**URL:** <https://forums.toadworld.com/t/set-reports-manager-on-multiple-databases/26022>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [July 30, 2013, 12:55am UTC](https://forums.toadworld.com/t/set-reports-manager-on-multiple-databases/26022 "2013-07-30T00:55:33Z")\
**Posts on this page:** 13\
**Page:** 1

<div class="post-metadata">

**Author:** ![tendrills](https://avatars.discourse-cdn.com/v4/letter/t/a9a28c/32.png) [@tendrills](https://forums.toadworld.com/u/tendrills)\
**Post date:** [July 30, 2013, 12:55am UTC](https://forums.toadworld.com/t/set-reports-manager-on-multiple-databases/26022/1 "2013-07-30T00:55:33Z")

</div>

Hello,

I’m a begginer at Toad and my work is to make reports with a couple of queries on my databases, like sum up all autoextends of the tablespaces…

But the thing is, I only found the possibility to make it on one database per time, is there a way to make it global to all databases connected ? Or do I have to do them all one by one, everytime I have a report to do ?

Thanks you,

Best regards.

Mat

---

<div class="post-metadata">

**Author:** ![Dennis\_Paulus](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/dennis_paulus/32/138_2.png) [@Dennis\_Paulus](https://forums.toadworld.com/u/Dennis_Paulus)\
**Post date:** [July 30, 2013, 4:50am UTC](https://forums.toadworld.com/t/set-reports-manager-on-multiple-databases/26022/2 "2013-07-30T04:50:37Z")

</div>

Hi Matt,

There are many different ways to do what you want. I would recommend using the Automation Designer (Utilities Menu) and use the Execute as Script action  
for the different database connections you need to run the queries on. You can then export the results to whatever format you want. You can also schedule to run the apps/actions you create whenever you want. This is probably the most efficient method -  
you can find more about Automation Designer in the Help.

Probably the simplest would just to use the ‘connect’ command and run as a script in the Editor (using F5) - connecting to each db you want to run the queries  
on.

Eg.

connect  
username/pwd@db1

select  
\*

from  
scott.emp;

connect  
username/pwd@db2

select  
\*

from scott.emp;

etc.

There are various other options in Toad as well, like saving your queries to SQL Recall and just running them as you need. The best thing I could suggest  
would be for you to go thru the help and become familiar with the different features Toad provides to find what best works for you.

Hope this helps.

Dennis

**From:** tendrills [[mailto:bounce-tendrills@toadworld.com](mailto:bounce-tendrills@toadworld.com)]

**Sent:** Tuesday, July 30, 2013 3:56 AM

**To:** [toadoracle@toadworld.com](mailto:toadoracle@toadworld.com)

**Subject:** [Toad for Oracle - Discussion Forum] Set Reports Manager on multiple databases ?

**[Set Reports Manager on multiple databases ?](http://gyk.r.mailjet.com/redirect/xw9ghfl6l2jkx4clxf92vg/www.toadworld.com/products/toad-for-oracle/f/10/t/19972.aspx)**

Thread created by tendrills

Hello,

I’m a begginer at Toad and my work is to make reports with a couple of queries on my databases, like sum up all autoextends of the tablespaces…

But the thing is, I only found the possibility to make it on one database per time, is there a way to make it global to all databases connected ? Or do I have to do them all one by one, everytime  
I have a report to do ?

Thanks you,

Best regards.

Mat

To reply, please reply-all to this email.

[Stop receiving emails](http://gyk.r.mailjet.com/redirect/k9pztp699lb10rjktnk8lw/www.toadworld.com/products/toad-for-oracle/f/10/t/19972.aspx?subscribe=false) on this subject.

Or [  
Unsubscribe from Toad for Oracle - General](http://gyk.r.mailjet.com/redirect/7lb8homhg03vmob98015yz/www.toadworld.com/products/toad-for-oracle/f/10.aspx?subscribe=false) notifications altogether.

Toad for Oracle - Discussion Forum

[Flag](http://gyk.r.mailjet.com/redirect/votdh7q6kd6lhw9sqt8cz2/www.toadworld.com/products/toad-for-oracle/f/10/t/19972.aspx?AbuseContentId=ab516af4-d7a5-4127-89e3-2f2626b40477&AbuseContentTypeId=46448885-d0e6-4133-bbfb-f0cd7b0fd6f7&AbuseFlag=true)  
this post as spam/abuse.

![](http://gyk.r.mailjet.com/75169644/4gWjmJ.gif)

---

<div class="post-metadata">

**Author:** ![Dennis\_Paulus](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/dennis_paulus/32/138_2.png) [@Dennis\_Paulus](https://forums.toadworld.com/u/Dennis_Paulus)\
**Post date:** [July 30, 2013, 4:55am UTC](https://forums.toadworld.com/t/set-reports-manager-on-multiple-databases/26022/3 "2013-07-30T04:55:36Z")

</div>

Just one more note about this - if you do decide to use Automation Designer and are just running queries - the Export Dataset action might work best for  
you if you want to export the result separately to different formats, like Excel, Delimited text, HTML, etc.

---

<div class="post-metadata">

**Author:** ![Bert\_Scalzo](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/bert_scalzo/32/274_2.png) [@Bert\_Scalzo](https://forums.toadworld.com/u/Bert_Scalzo)\
**Post date:** [July 30, 2013, 5:05am UTC](https://forums.toadworld.com/t/set-reports-manager-on-multiple-databases/26022/4 "2013-07-30T05:05:36Z")

</div>

Note that Mark wrote an excellent doc on the automation designer and there were several blogs about it on Toad World. So check them out – and all the great  
stuff on Toad World J

**From:** Dennis Paulus [[mailto:bounce-Dennis\_Paulus@toadworld.com](mailto:bounce-Dennis_Paulus@toadworld.com)]

**Sent:** Tuesday, July 30, 2013 6:56 AM

**To:** [toadoracle@toadworld.com](mailto:toadoracle@toadworld.com)

**Subject:** RE: [Toad for Oracle - Discussion Forum] Set Reports Manager on multiple databases ?

**[ RE: Set Reports Manager on multiple databases  
?](http://gyk.r.mailjet.com/redirect/hl5vh1rfv3plfocq1ybbk6/www.toadworld.com/products/toad-for-oracle/f/10/p/19972/40266.aspx#40266)**

Reply by Dennis Paulus

Just one more note about this - if you do decide to use Automation Designer and are just running queries - the Export Dataset action might work best for you  
if you want to export the result separately to different formats, like Excel, Delimited text, HTML, etc.

To reply, please reply-all to this email.

[Stop receiving emails](http://gyk.r.mailjet.com/redirect/ot6ltcd7nrszbcpzr2ocrp/www.toadworld.com/products/toad-for-oracle/f/10/t/19972.aspx?subscribe=false) on this subject.

Or [  
Unsubscribe from Toad for Oracle - General](http://gyk.r.mailjet.com/redirect/t5wthy52h6h703sltopflx/www.toadworld.com/products/toad-for-oracle/f/10.aspx?subscribe=false) notifications altogether.

Toad for Oracle - Discussion Forum

[Flag](http://gyk.r.mailjet.com/redirect/of4whtb35wbgw8mtltcby3/www.toadworld.com/products/toad-for-oracle/f/10/p/19972/40266.aspx?AbuseContentId=1c9f227c-edb4-49ae-ad31-69ec22ba6912&AbuseContentTypeId=f586769b-0822-468a-b7f3-a94d480ed9b0&AbuseFlag=true)  
this post as spam/abuse.

![](http://gyk.r.mailjet.com/19e3855b/4haZK5.gif)

---

<div class="post-metadata">

**Author:** ![tendrills](https://avatars.discourse-cdn.com/v4/letter/t/a9a28c/32.png) [@tendrills](https://forums.toadworld.com/u/tendrills)\
**Post date:** [July 31, 2013, 2:39am UTC](https://forums.toadworld.com/t/set-reports-manager-on-multiple-databases/26022/5 "2013-07-31T02:39:03Z")

</div>

Hi Dennis and Bert, and thank you for your answers.

When I use the script mode, I got my output in txt file, but I’d prefer it in a much better output like excel or even html, so I tried the Export Dataset action, but when I use “connect username/pwd@db1”, it doesn’t like it at all.

I only can use it for the active connection.

Isn’t there an option to get reports by sql using the same method as in Backup Reporter ? Like, you click on the connection that you want your report to be ?

Mat

---

<div class="post-metadata">

**Author:** ![Dennis\_Paulus](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/dennis_paulus/32/138_2.png) [@Dennis\_Paulus](https://forums.toadworld.com/u/Dennis_Paulus)\
**Post date:** [July 31, 2013, 4:20am UTC](https://forums.toadworld.com/t/set-reports-manager-on-multiple-databases/26022/6 "2013-07-31T04:20:41Z")

</div>

Hi Mat,

Yes, in Automation Designer, if you use the ‘Export Dataset’ action, you simply put your query on the Dataset tab (no need to include the connect string),  
and then on the options tab select the format you want to export it to (Excel, HTML, etc.). For the connection part - in the upper left hand corner there is a connection button that will control what database it is run on. Add multiple actions for the different  
db’s you want to run your queries on.

So, if you want to run it on multiple databases do the following:

1. Add ‘Export Dataset’ app

2. Set the connection to the database you want. Set the output options. Paste your query.

3. Add another ‘Export Dataset’ app

4. Set the connection to another database you want. Set the output options. Paste your query.

– Repeat for all databases and queries you want

Then to run, you can…

1. Run the whole app and it will produce all your output files in one run

2. Run the individual actions as you want

3. Or schedule the App/actions to run automatically whenever is best for you, even if you are not at your computer.

The little script I sent before is only if you don’t care about format and to give you an example of how the same query can be run on multiple db’s using  
a script. I recommend using the AD for the best results and ease of use. It’s a very powerful tool.

Hope this helps,

Dennis

**From:** tendrills [[mailto:bounce-tendrills@toadworld.com](mailto:bounce-tendrills@toadworld.com)]

**Sent:** Wednesday, July 31, 2013 5:26 AM

**To:** [toadoracle@toadworld.com](mailto:toadoracle@toadworld.com)

**Subject:** RE: [Toad for Oracle - Discussion Forum] Set Reports Manager on multiple databases ?

**[ RE: Set Reports Manager on multiple databases  
?](http://gyk.r.mailjet.com/redirect/yvxdtt8xbo7x6hqcftrwft/www.toadworld.com/products/toad-for-oracle/f/10/p/19972/40346.aspx#40346)**

Reply by tendrills

Hi Dennis and Bert, thank you very much, it worked !

But if I may ask, is there any way to get the results in a “beautiful” pdf, using a Report Def File or something ?

Because my only output is a txt file.

Or maybe a way to call a report from reports manager in an app in automation designer ?

Mat

To reply, please reply-all to this email.

[Stop receiving emails](http://gyk.r.mailjet.com/redirect/hq7qtgj74mb5xrs15nzz4x/www.toadworld.com/products/toad-for-oracle/f/10/t/19972.aspx?subscribe=false) on this subject.

Or [  
Unsubscribe from Toad for Oracle - General](http://gyk.r.mailjet.com/redirect/2j5jh2vrrqhg0x1hv3vrzo/www.toadworld.com/products/toad-for-oracle/f/10.aspx?subscribe=false) notifications altogether.

Toad for Oracle - Discussion Forum

[Flag](http://gyk.r.mailjet.com/redirect/nxb4to9wwpootzvzv1h5h7/www.toadworld.com/products/toad-for-oracle/f/10/p/19972/40346.aspx?AbuseContentId=c6891cff-955f-4556-85ca-83ff035774e9&AbuseContentTypeId=f586769b-0822-468a-b7f3-a94d480ed9b0&AbuseFlag=true)  
this post as spam/abuse.

![](http://gyk.r.mailjet.com/0f2c5b3e/4i0UnS.gif)

---

<div class="post-metadata">

**Author:** ![Dennis\_Paulus](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/dennis_paulus/32/138_2.png) [@Dennis\_Paulus](https://forums.toadworld.com/u/Dennis_Paulus)\
**Post date:** [July 31, 2013, 4:25am UTC](https://forums.toadworld.com/t/set-reports-manager-on-multiple-databases/26022/7 "2013-07-31T04:25:40Z")

</div>

Hi Mat - see my last email - there is no need to use the connect string when using the Export Dataset action, as the connection button (upper Left hand corner)  
takes care of that for you.

**From:** tendrills [[mailto:bounce-tendrills@toadworld.com](mailto:bounce-tendrills@toadworld.com)]

**Sent:** Wednesday, July 31, 2013 5:40 AM

**To:** [toadoracle@toadworld.com](mailto:toadoracle@toadworld.com)

**Subject:** RE: [Toad for Oracle - Discussion Forum] Set Reports Manager on multiple databases ?

**[ RE: Set Reports Manager on multiple databases  
?](http://gyk.r.mailjet.com/redirect/oo0gh33bylvmnlxry1vdbk/www.toadworld.com/products/toad-for-oracle/f/10/p/19972/40347.aspx#40347)**

Reply by tendrills

Hi Dennis and Bert, and thank you for your answers.

When I use the script mode, I got my output in txt file, but I’d prefer it in a much better output like excel or even html, so I tried the Export Dataset action, but when I use “connect username/pwd@db1”,  
it doesn’t like it at all.

I only can use it for the active connection.

Isn’t there an option to get reports by sql using the same method as in Backup Reporter ? Like, you click on the connection that you want your report to be ?

Mat

To reply, please reply-all to this email.

[Stop receiving emails](http://gyk.r.mailjet.com/redirect/zlnhhpy5ovfw9nhyzs5cxp/www.toadworld.com/products/toad-for-oracle/f/10/t/19972.aspx?subscribe=false) on this subject.

Or [  
Unsubscribe from Toad for Oracle - General](http://gyk.r.mailjet.com/redirect/qgfvh6rf6mk636cfs94xyd/www.toadworld.com/products/toad-for-oracle/f/10.aspx?subscribe=false) notifications altogether.

Toad for Oracle - Discussion Forum

[Flag](http://gyk.r.mailjet.com/redirect/777ch21zk5d12nv0hcpcfj/www.toadworld.com/products/toad-for-oracle/f/10/p/19972/40347.aspx?AbuseContentId=5dbd8661-b323-473f-ad3e-38dfe07e1373&AbuseContentTypeId=f586769b-0822-468a-b7f3-a94d480ed9b0&AbuseFlag=true)  
this post as spam/abuse.

![](http://gyk.r.mailjet.com/d625ab31/4i1AlE.gif)

---

<div class="post-metadata">

**Author:** ![Bert\_Scalzo](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/bert_scalzo/32/274_2.png) [@Bert\_Scalzo](https://forums.toadworld.com/u/Bert_Scalzo)\
**Post date:** [July 31, 2013, 6:05am UTC](https://forums.toadworld.com/t/set-reports-manager-on-multiple-databases/26022/8 "2013-07-31T06:05:41Z")

</div>

When you are in Toad Editor and have a SQL command whose output you like in the data grid – but now want that output as a PDF file – just do right-hand-mouse  
menu on data grid and choose report. Now you’re thrown into Toad complete report designer utility with your query sent over. Should take just a few mouse clicks to choose your report header, layout, footers, etc. as you would do in any report designer tool  
– then choose run and finally save as PDF file. Takes like 30 seconds from start to finish ….

**From:** tendrills [[mailto:bounce-tendrills@toadworld.com](mailto:bounce-tendrills@toadworld.com)]

**Sent:** Wednesday, July 31, 2013 4:26 AM

**To:** [toadoracle@toadworld.com](mailto:toadoracle@toadworld.com)

**Subject:** RE: [Toad for Oracle - Discussion Forum] Set Reports Manager on multiple databases ?

**[ RE: Set Reports Manager on multiple databases  
?](http://gyk.r.mailjet.com/redirect/v24ohwhchqkk5pyh5ot2s4/www.toadworld.com/products/toad-for-oracle/f/10/p/19972/40346.aspx#40346)**

Reply by tendrills

Hi Dennis and Bert, thank you very much, it worked !

But if I may ask, is there any way to get the results in a “beautiful” pdf, using a Report Def File or something ?

Because my only output is a txt file.

Or maybe a way to call a report from reports manager in an app in automation designer ?

Mat

To reply, please reply-all to this email.

[Stop receiving emails](http://gyk.r.mailjet.com/redirect/n3x6t1wvcb1nt9fkrgvdqm/www.toadworld.com/products/toad-for-oracle/f/10/t/19972.aspx?subscribe=false) on this subject.

Or [  
Unsubscribe from Toad for Oracle - General](http://gyk.r.mailjet.com/redirect/rhxdt98rlzyp3glwlkhm5y/www.toadworld.com/products/toad-for-oracle/f/10.aspx?subscribe=false) notifications altogether.

Toad for Oracle - Discussion Forum

[Flag](http://gyk.r.mailjet.com/redirect/32f4twzomk1v71nqc093z3/www.toadworld.com/products/toad-for-oracle/f/10/p/19972/40346.aspx?AbuseContentId=c6891cff-955f-4556-85ca-83ff035774e9&AbuseContentTypeId=f586769b-0822-468a-b7f3-a94d480ed9b0&AbuseFlag=true)  
this post as spam/abuse.

![](http://gyk.r.mailjet.com/f1fb6f62/4i0Uvb.gif)

---

<div class="post-metadata">

**Author:** ![tendrills](https://avatars.discourse-cdn.com/v4/letter/t/a9a28c/32.png) [@tendrills](https://forums.toadworld.com/u/tendrills)\
**Post date:** [July 31, 2013, 7:10am UTC](https://forums.toadworld.com/t/set-reports-manager-on-multiple-databases/26022/9 "2013-07-31T07:10:53Z")

</div>

Hi Dennis,

Thanks again !

Just one little thing, do you know if is there a way to have them all in the same file ?

Thank you,

Mat

edit : Thank you too Bert, didn’t knew about this way !

---

<div class="post-metadata">

**Author:** ![Dennis\_Paulus](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/dennis_paulus/32/138_2.png) [@Dennis\_Paulus](https://forums.toadworld.com/u/Dennis_Paulus)\
**Post date:** [July 31, 2013, 8:25am UTC](https://forums.toadworld.com/t/set-reports-manager-on-multiple-databases/26022/10 "2013-07-31T08:25:42Z")

</div>

Let’s say that you using the AD Export Dataset Actions to export your results and you want to export to an Excel Instance. There is a sheet name field which  
you could populate with separate names (eg your dbname), and then run the app and it’ll export the results from each action to a separate sheet.

Every format has different options associated with it, so you really just have to play with it to find what works best for you. If you run it as a script,  
then you can easily do this, but then your formatting is limited. AD is a very powerful tool, so it really depends on what you want to do with it and how much time you want to spend and how creative you want to be  
J.

**From:** tendrills [[mailto:bounce-tendrills@toadworld.com](mailto:bounce-tendrills@toadworld.com)]

**Sent:** Wednesday, July 31, 2013 10:11 AM

**To:** [toadoracle@toadworld.com](mailto:toadoracle@toadworld.com)

**Subject:** RE: [Toad for Oracle - Discussion Forum] Set Reports Manager on multiple databases ?

**[ RE: Set Reports Manager on multiple databases  
?](http://gyk.r.mailjet.com/redirect/c30jtgz197tgyvm34sjqnv/www.toadworld.com/products/toad-for-oracle/f/10/p/19972/40359.aspx#40359)**

Reply by tendrills

Hi Dennis,

Thanks again !

Just one little thing, do you know if is there a way to have them all in the same file ?

Thank you,

Mat

To reply, please reply-all to this email.

[Stop receiving emails](http://gyk.r.mailjet.com/redirect/md54t07cqox7y99o4y9v9r/www.toadworld.com/products/toad-for-oracle/f/10/t/19972.aspx?subscribe=false) on this subject.

Or [  
Unsubscribe from Toad for Oracle - General](http://gyk.r.mailjet.com/redirect/2dy9thrrokr2qfhp4s54t6/www.toadworld.com/products/toad-for-oracle/f/10.aspx?subscribe=false) notifications altogether.

Toad for Oracle - Discussion Forum

[Flag](http://gyk.r.mailjet.com/redirect/vbz4tlh4hyrwcf47vpcfhd/www.toadworld.com/products/toad-for-oracle/f/10/p/19972/40359.aspx?AbuseContentId=c2b8911c-8b46-42bb-a199-70c2a3223658&AbuseContentTypeId=f586769b-0822-468a-b7f3-a94d480ed9b0&AbuseFlag=true)  
this post as spam/abuse.

![](http://gyk.r.mailjet.com/ce0c6d22/4idcfR.gif)

---

<div class="post-metadata">

**Author:** ![tendrills](https://avatars.discourse-cdn.com/v4/letter/t/a9a28c/32.png) [@tendrills](https://forums.toadworld.com/u/tendrills)\
**Post date:** [August 1, 2013, 1:06am UTC](https://forums.toadworld.com/t/set-reports-manager-on-multiple-databases/26022/11 "2013-08-01T01:06:37Z")

</div>

Hello,

I already tried this setup, but unfortunatly, it still replace the file by a new one everytime.

Thank you anyway 🙂

---

<div class="post-metadata">

**Author:** ![alancounihan](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/alancounihan/32/31_2.png) [@alancounihan](https://forums.toadworld.com/u/alancounihan)\
**Post date:** [August 6, 2013, 6:09am UTC](https://forums.toadworld.com/t/set-reports-manager-on-multiple-databases/26022/12 "2013-08-06T06:09:42Z")

</div>

Created an entry in the idea pond for this for people to vote on

[toadfororacle.ideascale.com/…/440565-8477](http://toadfororacle.ideascale.com/a/dtd/Automation-Desginer-one-report-for-muliple-connections/440565-8477)

---

<div class="post-metadata">

**Author:** ![Dennis\_Paulus](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/dennis_paulus/32/138_2.png) [@Dennis\_Paulus](https://forums.toadworld.com/u/Dennis_Paulus)\
**Post date:** [August 14, 2013, 5:42am UTC](https://forums.toadworld.com/t/set-reports-manager-on-multiple-databases/26022/13 "2013-08-14T05:42:20Z")

</div>

Sorry - I didn’t see the response to this. Did you try using ‘Excel Instance’ as the output format, and then setting the ‘Sheet name’ field?