Chatta subito con l'assistenza
Chat con il supporto

Toad Data Point 6.1 - User Guide

ODBC Reports

The following reports are available for the Toad Sample Database in the Reports Manager (Tools | Reports | Reports Manager):

Report Name Description
Customer orders Displays customer orders for contact IDs less than 10 from the Toad sample database. It is an example of master detail display using a single result set.
Customer list Displays a list of customers from the Toad sample database.
Items to order Displays items in stock that have a quantity of less than 50 and should be reordered from the Toad sample database.

 

Related Topics

Oracle Reports

The following reports are available from the Reports Manager (Tools | Reports | Reports Manager).

Show all

 

Related Topics

SQL Server Reports

The following reports are available from the Reports Manager (Tools | Reports | Reports Manager).

Show all

 

Related Topics

Publish and Share Reports

Toad provides multiple ways to publish and share information with your business community. Use the following methods to publish and share information from the Project Manager, Reports Manager, and Automation.

  • Email reports and files, including Database Diagrams, Query Builder queries, SQL scripts, and results for reports, queries, and scripts.
  • Share reports and files in a central location such as the Toad shared folder.
  • Add reports and files to a ZIP folder or file.
  • Publish reports and files to Toad Intelligence Central

You can use the following methods to publish and share information:

To email from...

Do this...

Automation

Drag the Send Email activity to the Automation workflow and attach files as needed. The email is sent when the automation script executes. See Use System Automation Activities for more information.

To publish to a central location from...

Do this...

Project Manager,
Reports Manager

Right-click a report or file and select Send To | Toad Shared. The file is sent to the Toad shared folder specified in Tools | Options | Environment | Network Share.

Automation

Drag the Copy File activity to the Automation workflow. Specify the file to copy or move and a destination folder. This can be any folder, including the Toad shared folder, or a network folder. The file is copied or moved when the automation script executes. See Use File Automation Activities for more information.

To send to a zip file...

Do this...

Automation

Drag the Zip File activity to the workflow. Add reports and files to the Zip file and specify a file name with a .zip extension. The ZIP file can then be emailed with the Send Email activity or copied with the Copy File activity. See Use File Automation Activities for more information.

To publish to Intelligence Central from... Do this...

Project Manager,

Reports Manager

Right-click a file and select Send To | Publish File. See Publish Toad Documents to Intelligence Central for more information.

Automation

Drag the Publish Files activity to the Automation workflow. Add reports and files created previously in the script or add other existing files. See Use File Automation Activities for more information.

Tips:

  • To export a Toad report to a file that can be read by other applications, double-click a report in the Reports Manager, click in the Report Preview window, select a file format, and add the file to a project. Share or publish the file using the Project Manager functions. See Project Manager for more information.

  • To capture report results in a file, add the Toad Report automation activity. This activity runs a Toad report and saves the results in a file format you select. Share or publish the file using the Automation functions. See Use Database Automation Activities for more information.

  • To execute and save a query in a file, add the Select To File automation activity. This activity runs a query or SQL script and exports the results to an Excel spreadsheet. Share or publish the spreadsheet using the Automation functions. See Use Database Automation Activities for more information.

 

Related Topics

Project Manager 

About Managing Reports 

Automate Tasks 

Related Documents

The document was helpful.

Seleziona valutazione

I easily found the information I needed.

Seleziona valutazione