Online Documentation for SQL Manager for DB2

Setting report options


Options dialog

 

The Options dialog allows you to specify a number of settings pertaining to the printing report.

 

To open the dialog, open the Design Report btnPrintData_DesignReport menu available on the toolbar and select the Preferences item.

 

Data View - Print Data - Report options

 

 

Show

Tick off the elements to show in the printing report (margins, margins hints, margins hints while dragging).

 

Use the Measurement Units drop-down list to select the unit of measure that will be used in report settings: default, inches, or millimeters.

 

Zoom Parameters

 

CheckBox Zoom on roll with IntelliMouse

If this option is selected, you can zoom in/out by scrolling up/down (with a Microsoft® mouse or a compatible mouse used).

 

Zoom Step

Use the spinner control to specify the percentage of the original page size to be considered as one zoom step.

 

Use the Margins Color drop-down list to select the color that will be applied to the report margins.

 

 

Report Title dialog

 

The Report Title dialog allows you to specify the report title text and properties.

 

To open the dialog, use the Title... btnPrintData_Title button available on the toolbar.

 

Data View - Print Data - Report options - Title

 

 

Mode

Use the drop-down list to select where the report title should be displayed on the first page, on every top page, or not displayed at all.

 

Text

Use the edit box to enter the text of the report title.

 

Properties

 

CheckBox Transparent

If this option is selected, the report title will be drawn transparent.

 

Use the Color drop-down list to select the color that will be applied to the report title (enabled if the CheckBox Transparent option is not selected).

 

Click the Font... button to specify title font properties using the standard Font dialog. The font name and size are displayed in the gray area next to the Font... button.

 

CheckBox Adjust on scale

If this option is selected, the title can be adjusted on scale.

 

Alignment

Use the Horizontally drop-down list to select the type of horizontal alignment to be applied to the report title: Left, Center, or Right.

Use the Vertically drop-down list to select the type of vertical alignment to be applied to the report title: Top, Center, or Bottom.

 

To restore the default title properties, click the Restore Defaults button.

 

 

Date and Time dialog

 

The Date and Time dialog allows you to specify the date/time formats to be used in the report.

 

To open the dialog, open the Title... btnPrintData_Title menu available on the toolbar and select the Date and Time... item.

 

Data View - Print Data - Report options - Date and Time

 

 

Select the preferable values from the Available Date Formats and the Available Time Formats lists. If necessary, you can specify that the date/time will be updated automatically.

 

To apply the default date/time format, click the Default... button.

 

 

Page Number Format dialog

 

The Page Number Format dialog allows you to specify the formats for page numbers to be used in the report.

 

To open the dialog, open the Title... btnPrintData_Title menu available on the toolbar and select the Page Numbering... item.

 

Data View - Print Data - Report options - Page Number Format

 

 

Select the preferable number format from the Number Format drop-down list.

 

Use the Page Numbering section to specify whether page numbering should continue from the previous section (if any) or start at the specified number.

 

To set the default numbering values, click the Default... button.

 

 

Zoom dialog

 

The Zoom dialog allows you to zoom the report page more better representation.

 

To open the dialog, open the Zoom btnPrintData_Zoom menu available on the toolbar and select the Setup zoom... item.

 

Data View - Print Data - Report options - Zoom

 

 

Select the preferable percentage of zoom value (500%, 200%, 150%, 100%, 75%, 50%, 25%, 10%) or specify one of frequently used values:

RadioButton Page Width

RadioButton Whole Page

RadioButton Two Pages

RadioButton Four Pages

RadioButton Many Pages (click the chart below and select the item you need)

 

If necessary, you can set a custom percent value using the Percent spinner control below.

 

The Preview area on the right illustrates the changes you have made.