MySQL Reporting GUI tool for Windows

Overview
The various toolbars accessible from the design workspace are documented in this section. The toolbars are dockable and follow the Office97 interface style. The toolbars are accessible from the View | Toolbars menu option of the Report Designer or by right-clicking on the docking area at the top of the Report Designer.

Standard Component Palette
To access this toolbar, select the View | Toolbars | Standard Components menu option from the Report Designer main menu. This toolbar will assist in creating the most commonly used report
components.

Label

Displays text. Assign the Caption property to control the text value. You can have the label resize automatically to fit a changing caption if you set the AutoSize property to True.

Memo

Prints multiple lines of plain text in a report. To set the value, assign a string list to the Lines property. To dynamically resize the memo during printing, set the Stretch property to True. Use the ShiftRelativeTo property to define dynamic relationships with other stretchable objects.

RichText

Prints formatted text. To set the value, assign the RichText property or use the LoadFromFile orLoadFromRTFStream methods. Use the ShiftRelativeTo property to define dynamic relationships with other stretchable objects. At design-time you can use the ReportBuilder's built-in RTF Editor to load, modify, and save rich text data stored in files.

SystemVariable

Displays common report information such as page number, page count, print date and time, date, and time. The type of information displayed is con-trolled by the VarType property. The format is controlled by the DisplayFormat property.

Image

Displays bitmaps and windows metafiles in reports. Assign the Picture property of this component in order to place an image in your report. Use
the Report Designer's built-in picture dialog to load images at design-time.

Line

Displays single and double lines (either vertical or horizontal.) Set the Style property to control whether the line is single or double. Set the Weight property to control the line thickness in points. Set the Position property to control whether the line is vertical or horizontal.

Shape

Prints various shapes (squares, rectangles, circles, ellipses). Set the Shape property to select a type of shape. Use the Brush and Pen properties to control the color and border respectively.

TeeChart

Displays standard (non-data-aware) TeeCharts. This component enables you to use TeeCharts inside the Report Designer. You can access the TeeChart editor via a popup menu.

BarCode

Renders barcodes. The string value assigned to the Data property is encoded based on the BarCode-Type. If the data to be encoded is in a database, use DBBarCode. The following symbologies are supported: Codabar, Code 128, Code 39, EAN-13, EAN-8, FIM A,B,C, Interleaved 2 of 5, PostNet, UPC-A, UPC-E.

Data Component Palette
To access this toolbar, select the View | Toolbars Data Components menu option from the Report Designer main menu. This toolbar will assist in creating data-aware report components.

DBText

Displays values from all types of database fields. Use the DisplayFormat property to format the value.

DBMemo

Prints plain text from a memo field of a database table. This control will automatically word-wrap the text. Set the Stretch property to True and the
component will dynamically resize to print all of the text. Use the ShiftRelativeTo property to define dynamic relationships with other stretchable objects.

DBRichText

Prints formatted text from a memo or BLOB field of a database table. This control will automatically word-wrap the text. Set the Stretch property to True and the component will dynamically resize to print all of the text. Use the ShiftRelativeTo property to define dynamic relationships with other
stretchable objects.

DBCalc

Used for simple database calculations (Sum, Min, Max, Count, and Average). The value can be reset when a group breaks using the ResetGroup property.

DBImage

Prints bitmaps or windows metafiles, which are stored in a database BLOB field.

DBBarCode

Renders barcodes based on the BarCodeType and the value supplied via the DataField property. The following symbologies are supported: Codabar, Code 128, Code 39, EAN-13, EAN-8, FIM A,B,C, Interleaved 2 of 5, PostNet, UPC-A, UPC-E.

DBTeeChart

Allows data-aware TeeCharts to be placed within a report.

DBCheckBox

Displays a checkbox based on the value of the field specified in theDataField property. Thiscomponent can be used with a Boolean field (or any other type of field via the BooleanTrue, BooleanFalse properties).

Advanced Component Palette
To access this toolbar, select the View | Toolbars | Advanced Components menu option from the Report Designer main menu. This toolbar will assist in creating advanced report components.

Region

Logically groups components together. Use the ShiftRelativeTo property to move the region in relation to another dynamically resizing component (such as Memo, RichText or child-type Sub-Report).

SubReport

Handles multiple master details, creates side-by-side reporting effects, and hooks reports together as one. If you need a report to print within the context of a band, use a child-type subreport. If you need to hook reports together, use a section type subreport.

CrossTab

Allows you to generate a set of calculations that summarizes the data from a database table. It displays the calculations in a grid format.

Standard Toolbar
To access this toolbar, select the View | Toolbars | Standard menu option from the Report Designer main menu. This toolbar will assist with saving the report layout, accessing the print and print preview options, and accessing the cut and paste operations.

New Report

Creates a blank report layout.

Open Report

Displays the Open dialog, allowing you to open an existing report layout.

Save Report

Saves a report layout to file.

Page Setup

Displays the Page Setup dialog, allowing you to set the paper size and configure the layout for the report.

Print

Displays the Print dialog before sending the report to the printer.

Print Preview

Displays the Print Preview window.

Cut

Cuts the currently selected components into the clipboard.

Copy

Copies the currently selected components into the clipboard.

Paste

Pastes the components in the clipboard into the report.

Edit Toolbar
To access this toolbar, select the View | Toolbars | Edit menu option from the Report Designer main menu. This toolbar will assist in setting the most important property or properties for the currently selected component.

1 No component selected

2 Data-aware component selected

This configuration allows the data pipeline and data field for the component to be set. The drop-down list on the left shows the data pipeline. The drop-down list on the right shows the field name.

3 Label component selected

Here a label component has been selected in the Report Designer. The Edit toolbar displays an edit box from which the label's caption can be set.

4 Shape component selected

Here a shape component has been selected in the
Report Designer. The Edit toolbar displays the dif-ferent
shape types.

5 Line component selected

This configuration allows you to move the line to the top, bottom, left, or right within the line's selection handles.

Format Toolbar
To access this toolbar, select the View | Toolbars | Format menu option from the Report Designer main menu. This toolbar will assist with setting the font and colors. It will also assist with layering the components.

Font Name
Selects the font name for textual components. Use TrueType fonts (indicated by a

icon) when possible. These render well on both the screen and printer. If you are using a dot-matrix printer, the print driver may supply printer fonts (indicated by a

icon) that you can use to speed up the printing of the report. Finally, fonts that have no icon to the left of the font name are screen fonts and should not be used in reports where WYSIWYG is required.

Font Size
Selects the font size. You can also type in this box to set the font size exactly.

Bold

Sets the font to bold.

Italic

Sets font to italic.

Underline

Sets font to underline.

Left Justify

Left justifies the text in the component.

Center

Centers the text in the component.

Right Justify

Right justifies the text in the component.

Font Color

Sets the font color.

Highlight Color

Sets the background color of the textual component.

Bring to Front

Brings the component to the front. The components in the front print last, and the components in the back print first. Use the Report Tree to see the exact layering of components within the band.

Send to Back

Sends the component to the back. The components in the front print last, and the components in the back print first. Use the Report Tree to see the exact layering of components within the band.

Align or Space Toolbar
To access this toolbar, select the View | Toolbars | Align or Space menu option from the Report Designer main menu. This toolbar will assist in positioning components relative to one another and relative to the band in which they appear.

Align Left Edges

Aligns a group of components with the leftmost position of the component that was selected first.

Align Horizontal Centers

Centers a group of components based on the horizontal center of the component that was firstselected.

Align Right Edges

Aligns a group of components with the rightmost position of the component that was selected first.

Align Top Edges

Aligns a group of components with the topmost position of the component that was selected first.

Align Vertical Centers

Aligns a group of components based on the vertical center of the component that was first selected.

Align Bottom Edges

Aligns a group of components with the bottommost position of the component that was selected first.

Space Horizontally

Spaces a set of components based on the leftmost position of the first component selected and the rightmost position of the last component selected.

Space Vertically

Spaces a set of components based on the topmost position of the first component selected and the bottommost position of the last component selected.

Center Horizontally in Band

Centers a component horizontally within a band.

Center Vertically in Band

Centers a component vertically within a band.

Size Toolbar
To access this toolbar, select the View | Toolbars | Size menu option from the Report Designer main menu.

Shrink Width

Determines the minimum width of all the selected components, and then sets the width of the components to that value.

Grow Width

Determines the maximum width of all the selected components, and then sets the width of the components to that value.

Shrink Height

Determines the minimum height of all the selected components, and then sets the height of the components to that value.

Grow Height

Determines the maximum height of all the selected components, and then sets the height of the components to that value.

Nudge Toolbar
To access this toolbar, select the View | Toolbars | Size menu option from the Report Designer main menu.

Nudge Up

Moves all selected components one pixel up.

Nudge Down

Moves all selected components one pixel down.

Nudge Left

Moves all selected components one pixel to the left.

Nudge Right

Moves all selected components one pixel to the right.

Draw Toolbar
To access this toolbar, select the View | Toolbars | Draw menu option from the Report Designer main menu. This toolbar will assist in setting the colors and borders of components.

Fill Color

For shapes, lines, and region components only. Sets the Brush.Color property. To set the color of a textual component, check the Highlight Color action of the Format toolbar.

Line Color

For shapes, lines, and region components only. Sets the Pen.Color property.

Line Thickness

For use with a Line component only. Sets the Weight property.

Line Style

For use with a Line component only. Sets the Pen.Style property.

The Report Tree
To access this tool window, select the View | Toolbars Report Tree menu option from the Report Designer main menu. This tool window is dockable on the left and right sides of the Report Designer. It can be used to organize components within each band. Components selected in the Report Tree are selected in the report layout. The upper portion of the Report Tree shows the main report object and any subreports nested within it. This feature can be helpful for organizing your subreports.

The Data Tree
To access this tool window, select the View | Toolbars | Data Tree menu option from the Report Designer main menu. This tool window is dockable on the left and right sides of the Report Designer. It can be used to create components within any band. Simply select a set of fields and drag the selection into the band. A set of corresponding data-aware components will be created.