Skip to main content

PivotGridControl.PrintFieldCellTemplateSelector Property

Gets or sets a template selector that chooses a print template for data cells based on custom logic. This is a dependency property.

Namespace: DevExpress.Xpf.PivotGrid

Assembly: DevExpress.Xpf.PivotGrid.v23.1.dll

NuGet Package: DevExpress.Wpf.PivotGrid


public DataTemplateSelector PrintFieldCellTemplateSelector { get; set; }

Property Value

Type Description

A DataTemplateSelector descendant that chooses a template based on custom logic.


A template that defines the presentation of data cells when the pivot grid is printed is specified by the PivotGridControl.PrintFieldCellTemplate property. If you have more than one template that can be used to render cells, you can implement custom logic to choose the required template. To do this, derive from the DataTemplateSelector class, implement the SelectTemplate method that returns a template which meets the required condition, and assign an instance of this class to the PrintFieldCellTemplateSelector property.

The PrintFieldCellTemplateSelector is used for those fields whose PivotGridField.PrintCellTemplateSelector property is not specified.

The PrintFieldCellTemplateSelector is in effect only if the PivotGridControl.PrintFieldCellTemplate property is set to null (Nothing in Visual Basic). Otherwise, the PivotGridControl.PrintFieldCellTemplate template is used.

If a field displays KPI data, the PivotGridControl.PrintFieldCellKpiTemplate and PivotGridControl.PrintFieldCellKpiTemplateSelector properties are used for this field.

To learn more, see Printing and Exporting.


This example demonstrates how to select print templates for the DXPivotGrid elements based on a custom logic.

The logic for selecting the data cell print template is based on the ratio of the data cell value to the grand total value. If the ratio is between 0.2 and 0.8, the template selector applies a template that highlights the cell text and adds the warning sign to the cell.


The complete sample project How to Select a Print Template Based on a Custom Logic is available in the DevExpress Examples repository.

using System;
using System.Windows;
using System.Windows.Controls;
using DevExpress.Xpf.PivotGrid;
using DevExpress.Xpf.Printing;

namespace DXPivotGrid_SelectingPrintTemplate {
    public partial class MainWindow : Window {
        public MainWindow() {
            picotGridControl1.DataSource =
                new nwindDataSetTableAdapters.SalesPersonTableAdapter().GetData();
        private void btnPrint_Click(object sender, RoutedEventArgs e) {
            PrintHelper.ShowPrintPreview(this, picotGridControl1);
    public class CellTemplateSelector : DataTemplateSelector {
        public override DataTemplate SelectTemplate(object item, DependencyObject container) {
            Window mainWindow = Application.Current.MainWindow;
            CellElementData cell = (CellElementData)item;
            // Calculate the ratio of the cell value to the grand total.
            double share = Convert.ToDouble(cell.Value) / Convert.ToDouble(cell.ColumnTotalValue);

            // Apply the Normal template to the Column Grand Total cells.
            if (cell.ColumnValue == null)
                return mainWindow.FindResource("NormalCellTemplate") as DataTemplate;

            // If the ratio is far from 0.5, use the Highlighted template.
            // Otherwise, use the Normal template.
            if (share > 0.8 || share < 0.2)
                return mainWindow.FindResource("HighlightedCellTemplate") as DataTemplate;
                return mainWindow.FindResource("NormalCellTemplate") as DataTemplate;
See Also