End users can enable the following built-in features of the OLAP Grid either through UI or a simple user-friendly API in code-behind.
Allows users to define conditions that, when met, format the font, color, and border settings of values and summary cells.
Used to format the cells of the control. Styling can be applied to column headers, row headers, summary cells, and value cells.
Users can freeze row and column headers while performing scroll operations to have a precise view of the content.
Help users retrieve information about a particular cell on clicking a hyperlink cell. This feature allows you to perform custom operations through code.
The drill-through feature obtains a list of raw items for a particular value cell or summary cell.
The normal layout looks like the pivot table in earlier Excel versions, allowing end users to view the parent and child members adjacent to each other.
The summary layout easily switches the summary position either to the top or bottom beside each member in the control.
The Excel-like layout simulates the pivot table look and feel of Excel with child members positioned below their parent member with some indent space.
The no-summaries layout hides the subtotal and grand total and shows only header and value cells.
Provides basic information about a value cell while the pointer hovers over it.
Export an OLAP Grid to Excel, Word, CSV, or PDF document. Several options are also provided to customize the exporting operations.