This is mainly focus on DateTime fields. They automatically create children name Day, Week and etc.They should be named “<parentName>.Day” Only for local field description Add in LocalDataSourceFieldDescriptionsProvider property named FormatDisplayNameAsName which turn on/off this functionality ((LocalDataSourceFieldDescriptionsProvider)((LocalDataSourceProvider)this.radPivotGrid1.DataProvider).FieldDescriptionsProvider).FormatDisplayNameAsFieldName= true
Steps to reproduce: 1. Add a RadPivotGrid to a form and populate it with data or use the one in the Demo application 2. Press Ctrl+A to select all cells 3, Press Ctrl+C to copy all cells to the clipboard You will get an exception.
RadPivot prints only left columns and the columns placed on the right part of the control do not print
For example: If you grouping using of DateTimeGroupDescription you should be able to format date as dd.MM.yyyy instead of Apr-22 Resolution: You can use the GroupElementFormatting event to format the text in the GroupDescription elements. Please, note that the developer should add an own logic for formatting a date (for example you should take the year and month from another fields)
Add support for custom calculated items. For example: Users should be able to calculate the subtotal for the given column based on other columns subtotals.
GroupDescriptions loose the Custom Name after dragging.
IMPROVE. RadPivotGrid - expose a method for accessing cell values
ADD. RadPivotGrid - add export to excel functionality
Drag the field contains date from field choicer control to Column data area. Then remove one of the sum field. The exception will thrown. Workaround: Use the DLLs for NET2.0
User is not able to open the Filter Popup Dialog when filter items contains DBNULL Workaround: Replace the DBNULL values with empty strings in your datatable.
ADD. RadPivotGrid - add localization provider
ADD. RadPivotGrid - add ability to filter by more than one condition - composite filters
To workaround, also add a handler to the AggregatesPositionElementCreating event.
Currently, you can only copy the contents of the data cells to the clipboard and it is not possible to include the column/row header names.
ADD. RadPivotGrid - add single selection mode and expose the selected cell in property
Developers should be able to set the initial state for rows and columns in RadPivotGrid.
If there are many row descriptions and the total width of the row headers area is larger than the width the of the control, the vertical scroll is not visible. The same applies for the horizontal scroll and the column headers area.
Consider the pivot PivotGrid >> Binding With RadChartView example in our demo application. RadChartView shows all cells that are selected and there is no api to interpolate or filter them.
It should be possible to group the fields in the "Choose fields" are when using LocalDataSourceProvider because in some cases when you join a few tables, you might end up with a large number of fields.
Due to an exception in the data engine, no data is displayed if there are DBNull values in the data source.