This object executes aggregate functions against table data and places the result in a text object which is used as a label.
| Displays the Alignment dialog for adjusting the horizontal and vertical alignment of the selected objects.
|
|
|
|
|
|
|
| Displays the Font dialog for the font style, size and color of the object
|
|
|
| Text is left justified
|
|
|
|
|
|
|
| Text is center justified
|
|
|
|
|
|
|
| Text is right justified
|
|
|
|
|
| Text is justified to both the left and right margins
|
|
|
| Unique identifier used when passing property parameters in statements calling the label
|
|
|
| Places the currently selected object on the foreground of layered objects
|
|
|
| Places the currently selected object in the background of layered objects
|
| Object will shrink or stretch automatically based on value displayed
|
| Object will display nothing if the value of the variable is zero
|
| Opens the Calculations dialog window for specifying an aggregate function and the BreakName from the list of defined Breaks
|
|
|
|
|
|
|
| Calc Type
|
|
|
| · | Count - Counts the number of rows in a given data set
|
| · | Sum - Sums the values of the rows in a given data set
|
| · | Minimum - Returns the minimum row value in a given data set
|
| · | Maximum - Returns the maximum row value in a given data set
|
| · | Average - Returns the average (SUM / COUNT) of the rows in a given data set
|
|
|
| Reset Break
|
|
|
| The ResetBreak property is used to specify a control group for a label calculation. Each time the data value of the field specified by the Break's Name property changes, the calculated value of the DBCalc control is reset to zero, and the calculation begins again.
|
|
|
| When the ResetBreak property is null, it can be set by dragging the label control into a BreakHeader or a BreakFooter band. This property can also be set by accessing the calculations dialog from the speed menu for the label control.
|
|
|
| Note:
|
|
|
| For DBLabel components, the ResetBreak property can be used to control the behavior of the SuppressRepeatedValues property. Normally the DBLabel component tracks the text value of a field, suppressing any repeated values. It does this without any regard to group breaks which may have a occurred. By associating a DBLabel component with group, you can force a DBLabel component to reprint when the group breaks.
|
|
|
| Opens the Format dialog window for specifying a Field Mask for the data
|
|
|
|
|
|
|
|
| For details on Format options, please see Understanding Display Formats.
|
| LookAhead is designed to allow you to display summary calculations in the title band, page footer calculations in the page header band, group footer calculations in the group header band and column footer calculations in the column header.
|
|
|
| When the LookAhead property is checked, the draw command which represents the component on the rendered page will continue to update with the most recent calculation value until the label completes the generation of the associated page, group or column.
|
|
|
| Note:
|
|
|
| The Label Pass Setting property must be set to Two Pass in order for LookAhead calculations to function reliably.
|
|
|
| Opens the Position dialog window for specifying hard-coded coordinates
|
|
|
|
| ReprintOnOverFlow applies to situations where a Stretchable component is stretching across pages. If the object overflows onto a new page, any components that are on the same band will reprint on the new page (if ReprintOnOverFlow is checked).
|
|
|
| The ReprintOnSubsequent property is used in conjunction with the SuppressRepeatedValues property. When SuppressRepeatedValues is checked, and detail lines have overflowed onto a new page, you can force the DataField to reprint on the first detail line of the new page by setting ReprintOnSubsequent to True.
|
| Opens the Reset Break dialog window for specifying the BreakName from the list of defined Breaks
|
|
|
|
|
|
| The ResetBreak property is used to specify a control group for a label calculation. Each time the data value of the field specified by the Break's Name property changes, the calculated value of the DBCalc control is reset to zero, and the calculation begins again.
|
|
|
| When the ResetBreak property is null, it can be set by dragging the label control into a BreakHeader or a BreakFooter band. This property can also be set by accessing the calculations dialog from the speed menu for the label control.
|
|
|
| Note:
|
|
|
| For DBLabel components, the ResetBreak property can be used to control the behavior of the SuppressRepeatedValues property. Normally the DBLabel component tracks the text value of a field, suppressing any repeated values. It does this without any regard to group breaks which may have a occurred. By associating a DBLabel component with group, you can force a DBLabel component to reprint when the group breaks.
|
| ShiftWithParent applies to situations where a Stretchable component is stretching. If ShiftWithParent is checked, the label component will move based on the amount of stretching the object requires. When you want components to appear at the bottom of an object, this is a useful feature. If the object stretches to a new page, the components will print on the next page.
|
|
|
| When the value of a variable is the same across several records, the SuppressRepeatedValues property allows you to print the value only once each time the field value changes. This can be useful in labels where a highly redundant field has been included in the detail band (for example, the City field in a label containing addresses.) If the detail band overflows onto a new page, you can force the suppressed value to print again by using the ReprintOnSubsequent property.
|
|
|
| To set the SuppressRepeatedValues property from the Label Designer, position your mouse cursor over the component and click the right mouse button. The SuppressRepeatedValues option will be displayed in the speedmenu. If it is checked, SuppressRepeatedValues is on. Selecting the SuppressRepeatedValues option from this menu will toggle its value.
|
| Allows the object to become transparent to the background object
|
| The Visible property determines whether a label component will be printed
|
| The WordWrap property determines whether the text of a label control has line breaks on word boundaries so that the text fits inside the control instead of being truncated.
|