R:BASE for Windows Report Designer includes the option of "Suppress Repeated Values" for Data Field objects. The default is set to False.
When the value of a field (as determined by the Data Field property) is the same across several records, the Suppress Repeated Values property allows you to print the value only once each time the field value changes. This can be useful in reports where a highly redundant field has been included in the Detail band (for example, the City field in a report containing addresses.) If the Detail band overflows onto a new page, you can force the suppressed value to print again by using the "Reprint On Subsequent" property.
You can use the "Reset Break" property to further control the behavior of Suppress Repeated Values. Normally the "DB Text" object tracks the text value of the field, suppressing any repeated values. It does this without any regard to breaks which may have occurred. By associating a DB Text object with a break, you can force values to reprint whenever there is a break, regardless of whether the text value was the same for the previous record.
To set the Suppress Repeated Values property in the Report Designer, position your mouse cursor over the DB Text object and click the right mouse button. The Suppress Repeated Values option will be displayed in the speed menu. If it is checked, Suppress Repeated Values is on. Selecting the Suppress Repeated Values option from this menu will toggle its value.
The "Reprint On Subsequent" property is used in conjunction with the "Suppress Repeated Values" property. When Suppress Repeated Values is set to True, and detail lines have overflowed onto a new page, you can force Data Field to reprint on the first detail line of the new page by setting Reprint On Subsequent to True. The defaults is set to False.
To set the Reprint On Subsequent property in the Report Designer, position your mouse cursor over the component and click the right mouse button. The Reprint On Subsequent option will be displayed in the speed menu. If it is checked, Reprint On Subsequent is on. Selecting the Reprint On Subsequent option from this menu will toggle its value
The Reset Break property is used to specify a control break for a report calculation. Each time the data value of the field specified by the Break's Break Name property changes, the calculated value of the "DB Calc" control is reset to zero, and the calculation begins again. When the Reset Break property is NULL, it can be set by dragging the report control into a Break Header or a Break Footer band. This property can also be set by accessing the calculations dialog from the speed menu for the report control.
Note: For "DB Text" objects, the Reset Break property can be used to control the behavior of the Suppress Repeated Values property. Normally the DB Text object tracks the text value of a field, suppressing any repeated values. It does this without any regard to breaks which may have a occurred. By associating a DB Text object with break, you can force a DB Text object to reprint when the break value changes.
