After upgrading PivotGrid control to version 10.1 the PivotGridFieldBase.UnboundExpression property doesn't calculate correctly anymore. I'm aware of Breaking Changes below. However this changes doesn't concern certain customers. Let suppose that a developer provided end-users with the capability to specify an unbound expression at runtime and save/load their custom layouts. After upgrade, this end-user will need to recreate an UnboundExpression to get the result. Moreover, the new calculation logic isn't suitable in some cases. E.g there are two data fields in the underlying data source "Price" and "Quantity", and we want to calculate the total cost based on this field. In the previous version, we can specify a "[Price] * [Quantity]" unbound expression to accomplish this task, but now this goal is inaccessible using the PivotGridFieldBase.UnboundExpression property.
So. I suppose that it is necessary to keep the default calculation logic the same as in the previous version, and add a property that will allow to change this behavior.
BC496: The data fields should have the Name property to supply a summary expression and the cell format style condition expression.
BC738: Unbound field expressions for data area fields are currently calculated on the summary level.
The PivotGrid.OptionsData.DataFieldUnboundExpressionMode property of the DataFieldUnboundExpressionMode enumeration type has been added. The default property value is DataFieldUnboundExpressionMode.Default. This value sets version 9.3 unbound expression calculation mode. The DataFieldUnboundExpressionMode.UseSummaryValues value sets an advanced version 10.1 mode - the unbound expression calculation of data fields is processed by the summary level.
Is your intention to post an answer to your own question?
- If so, then proceed.
- If you simply wanted to post additional information, ask for further clarification, or to just say "Thanks!", please click Leave a Comment.
- If you wish to edit your original question, please use the Edit button in the Toolbox at the top right corner of that entry.