How to: Print a PivotGrid and Show its Print Preview

• Nov 13, 2018

The following example demonstrates how to print the Pivot Grid control using the PivotGridControl.Print method and show its Print Preview window using the PivotGridControl.ShowPrintPreview method.

Note

Printing functionality depends on the DevExpress.XtraPrinting library. To verify that the library is available, use the PivotGridControl.IsPrintingAvailable property.

You can access print settings and modify them using the PivotGridControl.OptionsPrint property.

C#

using DevExpress.XtraPivotGrid;
// ...

private void ShowPivotGridPreview(PivotGridControl pivotGrid) {
    // Verify that the Pivot Grid Control can be printed.
    if (!pivotGrid.IsPrintingAvailable) {
        MessageBox.Show("Missing DevExpress.XtraPrinting library", "Error");
        return;
    }
    pivotGrid.ShowPrintPreview();
}

private void PrintPivotGrid(PivotGridControl pivotGrid) {
    // Verify that the Pivot Grid Control can be printed.
    if (!pivotGrid.IsPrintingAvailable) {
        MessageBox.Show("Missing DevExpress.XtraPrinting library", "Error");
        return;
    }
    pivotGrid.Print();
});
}

VB.NET

Imports DevExpress.XtraPivotGrid
' ...

Sub ShowPivotGridPreview(ByVal pivotGrid As PivotGridControl)
   ' Verify that the Pivot Grid Control can be printed.
   If Not pivotGrid.IsPrintingAvailable Then
        MessageBox.Show("Missing DevExpress.XtraPrinting library", "Error");
      Return
   End If
   pivotGrid.ShowPrintPreview()
End Sub

Sub PrintPivotGrid(ByVal pivotGrid As PivotGridControl)
   ' Verify that the Pivot Grid Control can be printed.
   If Not pivotGrid.IsPrintingAvailable Then
        MessageBox.Show("Missing DevExpress.XtraPrinting library", "Error");
      Return
   End If
   pivotGrid.Print()
End Sub

The image below shows the result.