Articles in this section
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

 

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