XRPivotGrid.PrintFieldValue Event

Enables you to render a different content for individual field values.

Namespace: DevExpress.XtraReports.UI

Assembly: DevExpress.XtraReports.v24.2.dll

NuGet Package: DevExpress.Reporting.Core

Declaration

C#

public event EventHandler<CustomExportFieldValueEventArgs> PrintFieldValue

VB.NET

Public Event PrintFieldValue As EventHandler(Of CustomExportFieldValueEventArgs)

Event Data

The PrintFieldValue event's data class is DevExpress.XtraReports.UI.PivotGrid.CustomExportFieldValueEventArgs.

Remarks

The PrintFieldValue event is raised for each field value when the XRPivotGrid is being printed. You can handle this event to change the field value’s appearance and contents in a printed document.

Example

This example demonstrates how to change the appearance of Pivot Grid value fields displayed in the column area using the XRPivotGrid.PrintFieldValue event.

C#

using System;
using System.Drawing;
using DevExpress.XtraReports.UI;
using DevExpress.XtraPrinting;
// ...

private void xrPivotGrid1_PrintFieldValue(object sender, DevExpress.XtraReports.UI.PivotGrid.CustomExportFieldValueEventArgs e) {
    if (e.Field != null && e.Field.Area == DevExpress.XtraPivotGrid.PivotArea.ColumnArea) {
        LabelBrick lb = new LabelBrick();
        lb.BackColor = Color.Beige;
        lb.Padding = new PaddingInfo(2, 2, 5, 2, GraphicsUnit.Pixel);
        lb.Text = e.Text;
        e.Brick = lb;
    }
}

VB.NET

Imports System
Imports System.Drawing
Imports DevExpress.XtraReports.UI
Imports DevExpress.XtraPrinting
' ...

Private Sub xrPivotGrid1_PrintFieldValue(sender As Object, e As DevExpress.XtraReports.UI.PivotGrid.CustomExportFieldValueEventArgs)
    If e.Field IsNot Nothing AndAlso e.Field.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea Then
        Dim lb As New LabelBrick()
        lb.BackColor = Color.Beige
        lb.Padding = New PaddingInfo(2, 2, 5, 2, GraphicsUnit.Pixel)
        lb.Text = e.Text
        e.Brick = lb
    End If
End Sub

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the PrintFieldValue event.

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#

winforms-dashboard-pivot-custom-export/CS/WinformsExport/Form1.cs#L44

pivot4.PrintCell += PivotPrintCell;
pivot4.PrintFieldValue += PivotPrintFieldValue;
pivot4.AfterPrint += PivotAfterPrint;

VB.NET

winforms-dashboard-pivot-custom-export/VB/WinFormsExport/Form1.vb#L46

AddHandler pivot4.PrintCell, AddressOf PivotPrintCell
AddHandler pivot4.PrintFieldValue, AddressOf PivotPrintFieldValue
AddHandler pivot4.AfterPrint, AddressOf PivotAfterPrint