The example shows how to customize the Pivot Grid dashboard item in the exported document when you handle the DashboardDesigner.CustomExport event.
This example contains several Pivot Grid items with different customization settings. The e.GetPrintableControl obtains the XRPivotGrid printable controls, and allows you to apply different customization settings for each item.
The CustomFieldValueCells event removes the "Kirkland" row and "1" and "3" quarter columns by names in the PivotCustomFieldValueCells event handler.
The FieldValueDisplayText event changes the display text in the quarter columns of the OrderDate field in the PivotFieldValueDisplayText event handler.
The CustomFieldValueCells event removes all rows whose grand total value is less than 200 in the PivotCustomFieldValueCellsVals event handler.
The CustomColumnWidth event sets the width of the "2" quarter column in the exported document in the PivotCustomColumnWidth event handler.
The CustomRowHeight event sets the height of the "London" row in the exported document in the PivotCustomRowHeight event handler.
The PrintFieldValue event customizes the appearance of the "Seattle" row in the PivotPrintFieldValue event handler.
The CustomFieldValueCells event changes the Grand Total column position to near in the PivotCustomFieldValueCellsResults event handler. The ShowRowGrandTotals property that is set to false hides the Grand Total row.
