Bind KetticPivotGrid with ChartView in C#.NET
KetticPivotGrid control can be used together with any other controls of Kettic WinForms UI components, including the KetticChartView control. The designers of user interface of PivotGrid are able to easily and seamlessly integrate this control into KetticChartView components to visualize the reports generated by KetticPivotGrid. In this article, we are going through the process of binding the KetticPivotGrid control with chart view in C#.NET template projects.
Bind KetticPivotGrid with KetticChartView
To bind the KetticPivotGrid control to chart view in .NET project, we shall assign a KetticPivotGrid instance as a DataSource of KetticChartView control. The simple C# code snippet below demonstrates how to achieve this.
Populate KetticChartView with Data via PivotGridChartDataProvider
KetticPivotGrid control provides the PivotGridChartDataProvider object for the users to populate KetticChartView control with data and customize the behaviors. To access the PivotGridChartDataProvider object, the KetticPivotGrid control offers the ChartDataProvider property.
Set PivotGridChartDataProvider object
Sometimes, we may not need to visualize the values of SubTotal and GrandTotal. The following C# code shows how to display one kind of totals.
Furthermore, we can customize one of the series, Bar, Line, and Area, to be generated, as well as the pivot axes to be applied.
C# Visualize Reports of KetticPivotGrid in Chart View
KetticPivotGrid control provides the options for the users to visualize the reports entirely or partially. Additionally, it allows the users to delay the data updates to KetticChartView. The C# code below shows how to achieve this.
PivotGridChartDataProvider C# events
KetticPivotGrid control provides two C# events, the CreateSeries and the CompletedUpdate, for the users to customize the generated series or apply custom series. The CreateSeries event is used to replace the series instance with a custom series and the CompletedUpdate event is used to apply any final settings to all series generated. The C# code below shows how to achieve this.
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