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