Category / Section
How to hide OLAP Grid summary columns and rows?
1 min read
You can hide the OLAP Grid summary columns and rows using the following code example.
C#
protected void Page_Load(object sender, EventArgs e) { this.OlapGrid1.RowBound += new EventHandler<RowBoundEventArgs>(OlapGrid1_RowBound); this.OlapGrid1.QueryColumnInfo += new EventHandler<ColumnInfoEventArgs>(OlapGrid1_QueryColumnInfo); } void OlapGrid1_QueryColumnInfo(object sender, ColumnInfoEventArgs e) { if (e.IsSummaryColumn) { var member = e.GetMember(); if (member.LevelDepth.ToString() == "0") { e.Hide(); } } } protected void OlapGrid1_RowBound(object sender, RowBoundEventArgs e) { if (e.IsSummaryRow) { var member = e.GetMember(); if (member.LevelDepth.ToString() == "0") { e.Hide(); } } }
VB
Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) AddHandler OlapGrid1.RowBound, AddressOf OlapGrid1_RowBound AddHandler OlapGrid1.QueryColumnInfo, AddressOf OlapGrid1_QueryColumnInfo End Sub Private Sub OlapGrid1_QueryColumnInfo(ByVal sender As Object, ByVal e As ColumnInfoEventArgs) If e.IsSummaryColumn Then Dim member = e.GetMember() If member.LevelDepth.ToString() = "0" Then e.Hide() End If End If End Sub Protected Sub OlapGrid1_RowBound(ByVal sender As Object, ByVal e As RowBoundEventArgs) If e.IsSummaryRow Then Dim member = e.GetMember() If member.LevelDepth.ToString() = "0" Then e.Hide() End If End If End Sub