This KB illustrates that how to expand all the members in the PivotGrid. Solution:By using DrillState enumeration, you can expand all the members in the PivotGrid. You can refer to the following code example. C#OlapReport olapReport = new OlapReport() { Name = "Default Report" }; olapReport.CurrentCubeName = "Adventure Works"; MeasureElements measureElement = new MeasureElements(); measureElement.Elements.Add(new MeasureElement { UniqueName = "[Measures].[Customer Count]" }); DimensionElement dimensionElementRow = new DimensionElement(); dimensionElementRow.Name = "Date"; dimensionElementRow.AddLevel("Fiscal", "Fiscal Year"); dimensionElementRow.DrillState = DrillState.ExpandAll; olapReport.SeriesElements.Add(dimensionElementRow); olapReport.CategoricalElements.Add(measureElement); return olapReport; VBDim olapReport As OlapReport = New OlapReport() With {.Name = "Default Report"} olapReport.CurrentCubeName = "Adventure Works" Dim measureElement As MeasureElements = New MeasureElements() measureElement.Elements.Add(New MeasureElement With {.UniqueName = "[Measures].[Customer Count]"}) Dim dimensionElementRow As DimensionElement = New DimensionElement() dimensionElementRow.Name = "Date" dimensionElementRow.AddLevel("Fiscal", "Fiscal Year") dimensionElementRow.DrillState = DrillState.ExpandAll olapReport.SeriesElements.Add(dimensionElementRow) olapReport.CategoricalElements.Add(measureElement) Return olapReport
|
This page will automatically be redirected to the sign-in page in 10 seconds.