XRLabel.ProcessDuplicatesMode Property

Specifies how to process a XRLabel control with duplicate values. See the ProcessDuplicatesMode enumeration description for information on the different duplicate processing modes.

Namespace: DevExpress.XtraReports.UI

Assembly: DevExpress.XtraReports.v23.2.dll

NuGet Package: DevExpress.Reporting.Core

Declaration

C#

[Browsable(true)]
public override ProcessDuplicatesMode ProcessDuplicatesMode { get; set; }

VB.NET

<Browsable(True)>
Public Overrides Property ProcessDuplicatesMode As ProcessDuplicatesMode

Property Value

Type	Description
ProcessDuplicatesMode	A ProcessDuplicatesMode enumeration value.

Available values:

Name	Description
Leave	Leaves all controls with identical values as is.
Merge	Merges controls with consecutive identical values into a single control. Note that this mode ignores controls with null values. Use the control’s ProcessNullValues property to process controls with null values.
Suppress	Removes all controls with consecutive identical values except the first control. Substitutes the removed controls with blank space.
SuppressAndShrink	Does the same as the Suppress mode and then shrinks blank space. Note that this mode cannot be used for intersecting controls and vertical bands.

Remarks

Use this property to process duplicate values of the XRLabel‘s Text or Tag property. Use the XRLabel‘s ProcessDuplicatesTarget property to set one of them.

The sample report screenshots below show how different duplicate processing modes are applied to the XRLabel control in the Country column.

Report Layout

Mode: Leave

Mode: Merge

Mode: Suppress

Mode: Suppress And Shrink

Note that if there are no controls on a band after duplicate values are removed, the band is not printed.

Mode: Leave

Mode: Suppress

In the previous images, all the values of the second and third table row are the same. After the duplicates on the third line are removed, the band is empty. Although the duplicate processing mode is set to Suppress, the band is not printed.

For more information, review the following help topics:

• Merge or Hide Duplicate and Empty Values
• Group Data by Days of the Week (Runtime Sample)

View Example: How to process duplicate values in a report

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the ProcessDuplicatesMode property.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

reporting-winforms-process-duplicate-values/CS/ProcessDuplicatesTarget/ProductReport.cs#L25

this.xrTableCell2.ExpressionBindings.Add(expressionBinding);
this.xrTableCell2.ProcessDuplicatesMode = ProcessDuplicatesMode.Merge;
this.xrTableCell2.ProcessDuplicatesTarget = DevExpress.XtraReports.UI.ProcessDuplicatesTarget.Tag;

VB.NET

reporting-winforms-process-duplicate-values/VB/ProcessDuplicatesTarget/ProductReport.vb#L22

Me.xrTableCell2.ExpressionBindings.Add(expressionBinding)
Me.xrTableCell2.ProcessDuplicatesMode = ProcessDuplicatesMode.Merge
Me.xrTableCell2.ProcessDuplicatesTarget = DevExpress.XtraReports.UI.ProcessDuplicatesTarget.Tag

reporting-winforms-group-by-days-of-week/VB/GroupByTimeSpan/Form1.vb#L53

detailLabel.ProcessDuplicatesTarget = ProcessDuplicatesTarget.Value
detailLabel.ProcessDuplicatesMode = ProcessDuplicatesMode.Suppress
detailBand.Controls.Add(detailLabel)