Let me explain the connection between RadPivotGrid
. In your code you should create a DataProvider and use it for both of the controls. If you use different providers, than all changes in RadPivotFieldList
will not apply on RadPivotGrid
. When you define group/aggregate descriptions, you define them on the DataProvider, not for RadPivotGrid
. Both controls will visualize what you've defined, but in a different way. When you use LocalDataSourceProvider, the top part of RadPivotFieldList
will show all public properties of the objects you have used as ItemsSource. But in your case you may not know what are the properties that must be shown there. And here is the usage of ICustomTypeProvider
. By using it you can add properties at runtime. Also you can define such properties as your group/aggregate descriptions. This way you can define group description at design time for a property which will be created at runtime. To create group descriptions at runtime, you can use RadPivotFieldList
(group description is created for each item placed in one of the bottom boxes of the FieldList - Rows, Columns, Filters, Values).
I'm not sure I fully understand this sentence: "or best way is to make one RadPivotGrid
by SQL table and define group descriptions", but you can use the data from an SQL statement for ItemsSource of your DataProvider and set group descriptions for it.
Do not hesitate to contact us if you still have any problems or concerns. You may also take a look at our online help
and particularly the "Understanding RadPivotGrid"
the Telerik team