Toad Data Point 6.1.2

Chat now with support

Create Amazon Redshift Connections Create ODBC Connections Create Oracle Connections Create Snowflake Connections Create SQL Server Connections Create SharePoint Connections Understand Toad Connections Troubleshoot SQL Server Connections

Understand

Determine the Best Method to Locate Objects Object Explorer Filter Databases and Objects Understand a Table Using the Database Explorer Search for Objects Create an Database Diagram to Use as a Query Template Browse Data in Related Tables

Query

Tutorial: Build a Query Visually Create Cross-Connection Queries Reverse Engineer Queries Build a Subquery Edit SQL Editor Shortcut Keys View Result Sets Compare Differences in Data Export Data with One Click Export Share Excel Linked Queries

Report

Tutorial: Create a Toad Data Report Manage Reports

About Managing Reports DB2 Reports MySQL Reports ODBC Reports Oracle Reports SQL Server Reports

Publish and Share Reports

Automate

Getting Started with Automation Tutorial: Automate Excel Reports Automate Tasks Use Database Automation Activities Use File Automation Activities Use System Automation Activities Use Variables In Automation Execute/Schedule Automation Scripts

Add Report Bands

A report band determines how and where controls from the Toolbox display in the report. The following report bands are available and can be added or removed from the Explorer tool window. See About Navigating Reports for more information.

Band	Description
TopMargin	Adds selected controls to the top margin of the report.
ReportHeader	Adds selected controls to the beginning of the report. The title of the report you entered in the Data Report wizard displays in this band.
PageHeader	Adds selected controls at the top of the report, directly below the TopMargin band. The "Report generated by Toad" banner displays in this band. This feature is also useful for repeating table headings across multiple pages.
GroupHeader	Adds selected controls to the beginning of a group of records in the Detail band if you are using grouping. If you selected any grouping options in the Group Data window of the Data Report Wizard, this band is automatically added to the report with the grouped fields you selected below the band.
Detail	Displays the fields you selected for the report.
GroupFooter	Adds selected controls at the end of a group. This band is not required if you have a GroupHeader band.
PageFooter	Adds selected controls to the bottom of the report, directly above the BottomMargin band. The date the report was generated displays in this band by default.
BottomMargin	Adds selected controls to the bottom margin of the report.

Please select your product:

To serve you better, please complete the Purpose of your Chat:

Recommended Solutions for Your Problem

Toad Data Point 6.1.2 - User Guide

Add Report Bands