ProcessDuplicatesTarget Enum

Lists the values that specify whether to process duplicate values of a report control’s data, or its XRControl.Tag property values.

Namespace: DevExpress.XtraReports.UI

Assembly: DevExpress.XtraReports.v18.2.dll

Declaration

C#

public enum ProcessDuplicatesTarget

VB.NET

Public Enum ProcessDuplicatesTarget

Members

Name	Description
Value	The XRControl.ProcessDuplicatesMode property is in effect for the reports control’s data.
Tag	The XRControl.ProcessDuplicatesMode property is in effect for the XRControl.Tag property of a report control.

Related API Members

The following properties accept/return ProcessDuplicatesTarget values:

• XRBarCode.ProcessDuplicatesTarget
• XRControl.ProcessDuplicatesTarget
• XRLabel.ProcessDuplicatesTarget
• XRPictureBox.ProcessDuplicatesTarget
• XRRichTextBase.ProcessDuplicatesTarget

Remarks

The following properties return a ProcessDuplicatesTarget value:

• XRBarCode.ProcessDuplicatesTarget
• XRLabel.ProcessDuplicatesTarget
• XRPictureBox.ProcessDuplicatesTarget
• XRRichTextBase.ProcessDuplicatesTarget

The code below demonstrates how you can process duplicate values of the report’s Category Name column.

C#

using DevExpress.XtraReports.UI;
//...
public partial class ProductsReport : DevExpress.XtraReports.UI.XtraReport {
    //...
        // Display duplicate values.
        public void NoMerge() {
            this.ShowPreviewDialog();
        }
        // Merge duplicate the XRControl.Tag property's values.
        public void MergeByTag() {
            ExpressionBinding expressionBinding = new ExpressionBinding("BeforePrint", "Tag", "ToStr([SupplierID]) + '_' + ToStr([CategoryID])");
            this.lbCategoryName.ExpressionBindings.Add(expressionBinding);
            this.lbCategoryName.ProcessDuplicatesMode = ProcessDuplicatesMode.Merge;
            this.lbCategoryName.ProcessDuplicatesTarget = DevExpress.XtraReports.UI.ProcessDuplicatesTarget.Tag;
            this.ShowPreviewDialog();
        }
        // Merge duplicate values of a report control's data. 
        public void MergeByValue() {
            ExpressionBinding expressionBinding = new ExpressionBinding("BeforePrint", "Text", "[CategoryName]");
            this.lbCategoryName.ExpressionBindings.Add(expressionBinding);
            this.lbCategoryName.ProcessDuplicatesMode = ProcessDuplicatesMode.Merge;
            this.lbCategoryName.ProcessDuplicatesTarget = DevExpress.XtraReports.UI.ProcessDuplicatesTarget.Value;
            this.ShowPreviewDialog();
        }
    }

VB.NET

Imports DevExpress.XtraReports.UI
'...
Partial Public Class ProductsReport
    Inherits DevExpress.XtraReports.UI.XtraReport

    '...
        ' Display duplicate values.
        Public Sub NoMerge()
            Me.ShowPreviewDialog()
        End Sub
        ' Merge duplicate the XRControl.Tag property's values.
        Public Sub MergeByTag()
      Dim expressionBinding As New ExpressionBinding("BeforePrint", "Tag", "ToStr([SupplierID]) + '_' + ToStr([CategoryID])")
            Me.lbCategoryName.ExpressionBindings.Add(expressionBinding)
            Me.lbCategoryName.ProcessDuplicatesMode = ProcessDuplicatesMode.Merge
            Me.lbCategoryName.ProcessDuplicatesTarget = DevExpress.XtraReports.UI.ProcessDuplicatesTarget.Tag
            Me.ShowPreviewDialog()
        End Sub
        ' Merge duplicate values of a report control's data. 
        Public Sub MergeByValue()
        Dim expressionBinding As New ExpressionBinding("BeforePrint", "Text", "[CategoryName]")
            Me.lbCategoryName.ExpressionBindings.Add(expressionBinding)
            Me.lbCategoryName.ProcessDuplicatesMode = ProcessDuplicatesMode.Merge
            Me.lbCategoryName.ProcessDuplicatesTarget = DevExpress.XtraReports.UI.ProcessDuplicatesTarget.Value
            Me.ShowPreviewDialog()
        End Sub
End Class

This image illustrates the result.

No Merge

ProcessDuplicatesTarget = Tag

ProcessDuplicatesTarget = Value

Tip

Online Example: How to process duplicate values in a report