Articles in this section
Category / Section

How to change the cell style in WPF OLAP Grid ?

1 min read

You can change the style of a particular cell in OLAP Grid inside the QueryCellInfo event as illustrated in the following code example.

C#

public MainWindow()
        {
            try
            {
                InitializeComponent();
                this.olapgrid.OlapDataManager = new OlapDataManager("Data Source=http://bi.syncfusion.com/olap/msmdpump.dll; Initial Catalog=Adventure Works DW 2008 SE;");
                this.olapgrid.OlapDataManager.SetCurrentReport(SampleReport());
                this.olapgrid.InternalGrid.QueryCellInfo += new Syncfusion.Windows.Controls.Grid.GridQueryCellInfoEventHandler(InternalGrid_QueryCellInfo);
            }
            catch (Exception ex)
            {
                ShowExceptionMessage(ex);
            }
        }
void InternalGrid_QueryCellInfo(object sender, Syncfusion.Windows.Controls.Grid.GridQueryCellInfoEventArgs e)
        {
            e.Style.CellType = "Value";
            e.Style.CellValue = "$234509000.00";
            e.Style.Background = Brushes.Cyan;
            e.Handled = true;
        }

VB

Private Function MainWindow() As Public
        Try
            InitializeComponent()
            Me.olapgrid.OlapDataManager = New OlapDataManager("Data Source=http://bi.syncfusion.com/olap/msmdpump.dll; Initial Catalog=Adventure Works DW 2008 SE;")
            Me.olapgrid.OlapDataManager.SetCurrentReport(SampleReport())
            Me.olapgrid.InternalGrid.QueryCellInfo += New Syncfusion.Windows.Controls.Grid.GridQueryCellInfoEventHandler(InternalGrid_QueryCellInfo)
        Catch ex As Exception
            ShowExceptionMessage(ex)
        End Try
    End Function
 Private Sub InternalGrid_QueryCellInfo(ByVal sender As Object, ByVal e As Syncfusion.Windows.Controls.Grid.GridQueryCellInfoEventArgs)
        e.Style.CellType = "Value"
        e.Style.CellValue = "$234509000.00"
        e.Style.Background = Brushes.Cyan
        e.Handled = True
    End Sub

 

Did you find this information helpful?
Yes
No
Help us improve this page
Please provide feedback or comments
Comments (0)
Please sign in to leave a comment
Access denied
Access denied