We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback


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.

Conditional formatting

Allows users to define conditions that, when met, format the font, color, and border settings of values and summary cells.

Conditional formatting support in WPF OLAP grid control

Grid style dialog in WPF OLAP grid control

Grid-style dialog

Used to format the cells of the control. Styling can be applied to column headers, row headers, summary cells, and value cells.

Freeze headers

Users can freeze row and column headers while performing scroll operations to have a precise view of the content.

Freeze headers in WPF OLAP grid control

Hyperlinks in WPF OLAP grid control

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.

Drill-through support in WPF OLAP grid control


Normal layout

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.

Normal view of WPF OLAP Grid control

Summary layout

The summary layout easily switches the summary position either to the top or bottom beside each member in the control.

Summary view of WPF OLAP Grid control

Excel-like layout

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.

Excel-like view of WPF OLAP Grid control

No summaries

The no-summaries layout hides the subtotal and grand total and shows only header and value cells.

No summary view of WPF OLAP Grid control

Tooltip support in WPF OLAP grid control


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.

Exports to Word, PDF, CSV and Excel support in WPF OLAP Grid control


Scroll up icon

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

Live Chat Icon For mobile
Live Chat Icon