Change Theme Settings
Change Theme Settings
Show All Themes

Unbound Fields

Page 1 of 5 (45 items)Prev12345Next
Extended Price[Filter]
Page 1 of 5 (45 items)Prev12345Next

The ASPxPivotGrid control allows you to create Unbound Fields which are not bound to any field in the control's underlying data source. These fields should be populated manually. For instance, they can display custom information and even use summary results calculated by the pivot grid.

In this demo, the Sales Person and Order Amount fields are unbound, and populated via the CustomUnboundFieldData event. These unbound fields are an equivalent of calculated columns provided by data sources. To specify how values for fields based on bound fields are calculated, use the Sales Person Format and Order Amount Rule combo boxes.

The Percent of OrderTotal and Bonus Amount unbound data fields are calculated using the CustomCellDisplayText event. Cell values of the Percent of OrderTotal field specify the percentage ratio of the current order's sum as compared to the order's total sum. Bonus Amount field values display 15% if the order amount is greater than $50,000 and 10% otherwise.

See Also:
Local Copy of this Demo
To inspect the source code for this demo on your machine, you must first install our components via the DevExpress Component Installer.
You can open a local copy of this online demo directly from this webpage (if using v20.2.8, 21.1.4 or higher).
Open CS Solution
Open VB Solution
The source code files for this demo are installed (by default) in the following directories:
\Users\Public\Documents\DevExpress Demos XX.X\Components\ASP.NET\CS\ASPxPivotGridDemos
\Users\Public\Documents\DevExpress Demos XX.X\Components\ASP.NET\VB\ASPxPivotGridDemos