|
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.
You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.
