Articles in this section

How to hide OLAP Grid summary columns and rows?

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)
Access denied
Access denied