WebGrid.NET Enterprise 6.0 comes with Interactive UI feature where you can customize the ChartView at run time. The pivoting rules for the Chart Interactive UI includes:
- ShowInChartFieldList
- CanAddToChartData
- CanAddToChartCategories
- CanAddToChartFilter
- CanAddToChartSeries
In this topic, you will learn how to customize Pivot Rules in WebGrid.
To customize Pivot Rules in WebGrid
- Open WebGrid.NET Designer.
- Switch to Advanced tab. Expand RootTable >> Columns.
- Choose appropriate WebGridColumn Properties, customize one or all properties from above pivoting rules. For example: Select OrderID and set ShowInChartFieldList to true.
- Run the project.