Report Title

Enter the title to appear on the printed report.

Selections Title

If the report SQL Query has parameters, the user will be prompted for the parameters when the report is run. The Selections Title will display as the title of the Report Selections form.

Retain BeforeReport Code

Retain BeforeReport Code in the generated report (that is, the report that appeared in the Report Designer before opening the Report Designer Wizard). This prevents the Report Wizard making unwanted changes to the BeforeReport Code.

When Selected, the Selections tab will be Read Only.

Retain AfterQuery Code

Retain AfterQuery Code in the generated report (that is, the report that appeared in the Report Designer before opening the Report Designer Wizard). This prevents the Report Wizard making unwanted changes to the AfterQuery Code.

Page Orientation

Select from:

• Automatic
• Portrait
• Landscape

Automatic will choose the optimal orientation. based on fitting columns on the page with a readable font size.

The field width.

Visible

When Selected, the field will be shown on the report.

Curr Code Field

The field that contains the currency code for this field.

Expression

When Selected, the Caption will be created as an Expression component.

When Clear, the Caption will be created as a Label component.

Total

When Selected, amounts are totalled to one figure.

Group

To group fields, enter a number (such as 1), and all fields with the same Group will be grouped together.

Selections Tab

Use the Selections tab when the report contains selections for the user to make when the report is run.

Name

The field name.

Caption

The prompt to be displayed on the report selections form.

Input Type

The type of input.

Style

The style of input to be used when prompting for and matching to the parameter.
Select from From, To, Equal, Equal Or All, From Equal or All, To Equal or All.

Note: Use From Equal or All and To Equal or All where you have Between parameters but only want a single Input prompt.

Lookup Source

The source for the input options.

If Blank

The action to take if the input is not entered. Select from Leave Blank, Set to First, Set to Last or Required.

Default Value

The input default value.

List Values

Where relevant, the list of available values.

Buttons

Generate (F9)

The Wizard builds bands and fields and assigns bands to the iterator, then returns you to the Design Window. From there, you can execute the report to test and edit.

Cancel (Esc)

Close the Report Designer Wizard and discard changes.