$99 VS $1000+. UI Control for ASP.NET AJAX(contains chart and gridview).
Windows Forms PivotGrid Control
Create interactive user interface of Pivot table, build summarizations and highlight specific data
Home > WinForms UI Controls > User Manual > Set Layout of PivotGrid in C#

KetticPivotGrid Layout Settings in C#.NET

KetticPivotGrid control for Windows Forms contains two different layouts, the Tabular layout and the Compact layout. The Tabular layout shows a data field in a separate rectangle area, in other words, it will show row descriptors in a separate column in KetticPivotGrid, and show for columns descriptors in a separate row in KetticPivotGrid. The Compact layout is to nest the data field descriptors in the same area, as is saved the space while applying a large number of fields.

Customize Layouts of KetticPivotGrid Control

The following C# code demonstrates how to set the layout of the column and row headers by modifying the properties of Tabular and Compact.

this.ketticPivotGrid1.ColumnHeadersLayout = Kettic.WinForms.UI.PivotLayout.Tabular;
this.ketticPivotGrid1.RowHeadersLayout = Kettic.WinForms.UI.PivotLayout.Compact;
The C# code below shows the processes of setting SubTotals and GrandTotals to KetticPivotGrid in your .NET Windows application.

this.ketticPivotGrid1.ColumnGrandTotalsPosition = Kettic.WinForms.UI.TotalsPos.First;
this.ketticPivotGrid1.RowGrandTotalsPosition = Kettic.WinForms.UI.TotalsPos.Last;
this.ketticPivotGrid1.ColumnsSubTotalsPosition = Kettic.WinForms.UI.TotalsPos.First;
this.ketticPivotGrid1.RowsSubTotalsPosition = Kettic.WinForms.UI.TotalsPos.Last;
KetticPivotGrid control provides header cells to each aggregate when more than one aggregate description are added. The users of the control are able to display or hide the cells in the column or row headers areas and customize the level of the aggregate descriptions. The C# code below demonstrates how to achieve this.

this.ketticPivotGrid1.AggregatesPosition = Kettic.Pivot.Core.PivotAxis.Columns;
this.ketticPivotGrid1.AggregatesLevel = 1;
UI Controlsfor Windows Forms
.NET WinForms UI Overview.NET WinForms UI Features.NET WinForms UI GuideC# WinForms UI DesignVB.NET WinForms UI Design
WinForms UI Controls