SubDetail band is a band which is used to link additional datasets into a form. The user can link the subdetail band to the master table or query components. Printing of the subdetail band will be before or after the master detail band.

The following is the example using detail and subdetail band to print a form. The detail band is connected with the master table whereas the subdetail band is connected with another table. The subdetail band is printed after each detail band record has been printed.

You can define the expression field to control which dataset record will be printed on the form.

The following options are available:

Table:

This is the dataset that is used by the subdetail band.

Color:

This defines the background color of the band.

Master:

The master is the table superior to the subdetail table. For each record in the master table a subdetail list is printed.

Only print if expression is true:

An expression can be used to control the band whether should be print or not. You can generate and edit the expression by the expression expert. The FORMachine 1.0 engine will check the expression boolean for a logical result of 'True' or 'False

Print

• before master-detailband: prints the subdetail records before printing their master record from the detail band
• at bottom of page: moves the band to the bottom of the page before printing it
• print header/footer even if dataset is empty: header and footer bands of the subdetail band will be printed even if there are no subdetail data records to print
• force new page: starts a new page before printing the band
• force new column: starts a new column before printing the band with multiple columns

Headerband:

This band is printed as a header before the subdetail data records are printed.

Footerband:

This band is printed as a footer after the subdetail data records have been printed.

Frame: see Standard bands