Set occurrences for a record

You can define how many child records are printed for each master record.

Note:

The Occurrences property is available only in business records for reports (.4rd files), not for forms (.4fd* files) or web services (.4ws or .4wsj files).

When fetching the children of a master record, you may have data that ends up fetching many, many records. Depending on the needs of your report, you may not need all of the child records printed. You can define the desired behavior with the Occurrences property in the .4rd file.
Figure: Report: number of rows to print

Report Business Record diagram highlighting the Occurrences property
Important:

In order for this property to affect the printing of lines, the children must be ordered. See Order records in the Business Records diagram.

Table 1. Occurrences property options
Option Description
1

The master record prints, and only the first fetched child record prints. All other child records are discarded.

If no child rows are fetched, a child row still must print. By default, it will be an empty child record.

You can add default values for the row using an OnComputedFields code event. Select the On Computed Fields property for the creation of the event. In the code event function you will need to test if the row has data. Test the primary key for NULL for a STRING type, or for zero if it is a numeric type, such as a SERIAL.

0 or 1

The master record prints, and only the first fetched child record prints. All other child records are discarded.

If no child rows are fetched, nothing is printed for the child record.

0 or more

The master record prints, and all fetched child records print, whether it be one child record or many child records.

If no child rows are fetched, nothing is printed for the child record.

1 or more

The master record prints, and all fetched child records print, whether it be one child record or many child records.

If no child rows are fetched, a child row still must print. By default, it will be an empty child record.

You can add default values for the row using an OnComputedFields code event. Select the On Computed Fields property for the creation of the event. In the code event function you will need to test if the row has data. Test the primary key for NULL for a STRING type, or for zero if it is a numeric type, such as a SERIAL.