The following are properties specific to Label objects.

Behavior section

  • Angle: specifies the angle to rotate the text to. Note that you may have to increase the height of the object to see all of the text.

  • Auto Width: turn this on to automatically size the width of the label to fit the contents. You won't see the label width increase in the Layout Area but when the report is run, the label for each record is sized appropriately.

  • Multiline: turn this on if the content contains any carriage returns or line feeds so the text has line breaks.

  • Process Duplicates: what should happen if the value for the field in this record is the same as the one in the previous record. The choices are:

    • Leave: display the value.

    • Merge: identical values are merged into a single column.

    • Suppress: display a blank space instead of the value.

    • Suppress and Shrink: don't display the value and shrink the height of the object.

  • Process Duplicates Target: specifies whether to process duplicate values of the Text or Tag property.

  • Process Null Values: what should happen if the value for the field in this record is null. The choices are:

    • Leave: display the value.

    • Suppress: display a blank space instead of the value.

    • Suppress and Shrink: don't display the value and shrink the height of the object.

Data section

  • Null Value Text: the text to display if the field's value is null, such as "Unknown" or "Empty."

  • Summary: specifies how to summarize the value. The sub-properties are:

    • Ignore Null Values: set this to Yes to ignore null values when performing the summarization.

    • Format String: the format to use.

    • Running: where the summary value should be reset back to 0: None, Group, Report, or Page.

    • Function: the type of summarization to do: Average, Count, Sum, Running Summary, Percentage, Max, Min, Median, Variance, Population Variance, Standard Deviation, Standard Population Deviation, Average (Distinct), Count (Distinct), Summary (Distinct), Variance (Distinct), Population Variance (Distinct), Standard Deviation (Distinct), Standard Population Deviation (Distinct), Record Number, and Custom.


© IQ reseller, 1996-2020 • Updated: 02/18/16
Comment or report problem with topic