How to expand WPF OLAP Grid upto "n" level while loading initially ?
You can expand OLAP Grid up to the “n” level while loading through the following code example.
C#
OlapReport olapReport = new OlapReport(); olapReport.CurrentCubeName = "Adventure Works"; DimensionElement dimensionElement = new DimensionElement() { Name = "Product" }; dimensionElement.AddLevel("Product Categories", "Category"); olapReport.SeriesElements.Add(dimensionElement); dimensionElement = new DimensionElement() { Name = "Date" }; dimensionElement.AddLevel("Fiscal", "Fiscal Year"); dimensionElement.DrillState = DrillState.ExpandToLevel; dimensionElement.DrillUpDownLevel = "Month"; olapReport.CategoricalElements.Add(dimensionElement); return olapReport;
VB
Dim olapReport As OlapReport = New OlapReport() olapReport.CurrentCubeName = "Adventure Works" Dim dimensionElement As DimensionElement = New DimensionElement() With {.Name = "Product"} dimensionElement.AddLevel("Product Categories", "Category") olapReport.SeriesElements.Add(dimensionElement) Dim TempDimensionElement As DimensionElement = New DimensionElement() With {.Name = "Date"} dimensionElement = New DimensionElement() With {.Name dimensionElement.AddLevel("Fiscal", "Fiscal Year") dimensionElement.DrillState = DrillState.ExpandToLevel dimensionElement.DrillUpDownLevel = "Month" olapReport.CategoricalElements.Add(dimensionElement) Return olapReport
Conclusion
I hope you enjoyed learning how to expand WPF OlapGrid upto"n"level while loading initially.
You can refer to our WPF Olap Grid feature tour page to know about its other groundbreaking feature representations and documentation, and how to quickly get started for configuration specifications. You can also explore our WPF Olap Grid example to understand how to create and manipulate data.
For current customers, you can check out our components from the License and Downloads page. If you are new to Syncfusion, you can try our 30-day free trial to check out our other controls.
If you have any queries or require clarifications, please let us know in the comments section below. You can also contact us through our support forums, Direct-Trac, or feedback portal. We are always happy to assist you!