This KB illustrates that how to clear all dimensions and disable the pager option. SolutionYou can clear all dimensions and disable the pager option using an external button through the following code example. C#protected void Button1_Click(object sender, EventArgs e) { OlapClient1.EnablePaging = false; this.OlapClient1.AxisElementBuilderColumn.Controls.Clear(); this.OlapClient1.AxisElementBuilderRow.Controls.Clear(); this.OlapClient1.AxisElementBuilderSlicer.Controls.Clear(); OlapDataManager DataManager = new OlapDataManager(@"Data Source = localhost; Initial Catalog = Adventure Works DW;"); OlapClient1.OlapDataManager = DataManager; OlapClient1.UpdateAxisElementBuilder(); if (this.OlapClient1.ActiveView == "Grid") OlapClient1.OlapGridCallBackPanel.ContentTemplateContainer.Controls.RemoveAt(OlapClient1.OlapGridCallBackPanel.ContentTemplateContainer.Controls.Count - 1); else OlapClient1.OlapChartCallBackPanel.ContentTemplateContainer.Controls.RemoveAt(OlapClient1.OlapChartCallBackPanel.ContentTemplateContainer.Controls.Count - 1); OlapClient1.DataBind(); } VBProtected Sub Button1_Click(ByVal sender As Object, ByVal e As EventArgs) OlapClient1.EnablePaging = False Me.OlapClient1.AxisElementBuilderColumn.Controls.Clear() Me.OlapClient1.AxisElementBuilderRow.Controls.Clear() Me.OlapClient1.AxisElementBuilderSlicer.Controls.Clear() Dim DataManager As OlapDataManager = New OlapDataManager("Data Source = localhost; Initial Catalog = Adventure Works DW;") OlapClient1.OlapDataManager = DataManager OlapClient1.UpdateAxisElementBuilder() If Me.OlapClient1.ActiveView = "Grid" Then OlapClient1.OlapGridCallBackPanel.ContentTemplateContainer.Controls.RemoveAt(OlapClient1.OlapGridCallBackPanel.ContentTemplateContainer.Controls.Count - 1) Else OlapClient1.OlapChartCallBackPanel.ContentTemplateContainer.Controls.RemoveAt(OlapClient1.OlapChartCallBackPanel.ContentTemplateContainer.Controls.Count - 1) End If OlapClient1.DataBind() End Sub
|
This page will automatically be redirected to the sign-in page in 10 seconds.