At a glance
- Choose the content and visibility condition for each row.
- Hide blank values or test the contents of a value.
- Set row frames and keep the leader connected to the visible label.
Row content and conditionsDefine what each row displays and when it should be hidden.
Choose the property for a row and add a prefix or suffix if you need text before or after its value.
Use Hide Row If to choose the condition that hides the row. Conditions can test whether a value is blank or undefined, equals specified text, or contains specified text. The inverse conditions let you hide a row when the test is not met.
Enable Ignore case when capitalisation should not affect a text comparison. For example, this allows differently capitalised versions of the same word to be treated alike.
Frames, spacing and leader connectionThe visible rows determine the final label arrangement.
When a row is hidden, the remaining rows close up rather than leaving an empty gap. Rows can have their own frames, fills and spacing.
Connect To determines the leader’s reference. Enable Ignore Unframed Rows if only framed content should be considered for the connection. If the row chosen for the connection is hidden, the leader connects to the centre of the visible label.