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
Syncfusion Feedback


Overview

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.


Drill-through

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


Visualization

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

Tooltip

Provides basic information about a value cell while the pointer hovers over it.


Exporting

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


95+ WPF CONTROLS

Scroll up icon