Forums Retired Products and Controls
Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
Close
Cortland
285
The all level and Dimensional Expansion
posted

Hi,

I have a couple of questions:

1) Is there anyway to not start at the All level when dropping a dimension member to the Rows section?

2) If  I place a dimension member from two or more disparate dimensions in the Rows sections and start out expanding the all level for each member it leads to expanding out all the membersfor each hierachy. In our current product if I were to put two dimensions, let's say an Order dimension and a Product dimension and first expand out Orders, I could then individually expand out the members of each order, not everything all at once. We have extremely large customer databases and expanding out every member of every hierachy could take quite a bit of time. Is there any way to implement this logic?

  • 7922
    Suggested Answer
    posted

    Hi

    There is a way to get around the all level. You could use the follow code

     pivotGrid.DataSource.Columns.CollectionChanged += Columns_CollectionChanged;

     void Columns_CollectionChanged(object sender, System.Collections.Specialized.NotifyCollectionChangedEventArgs e)
    {
        if (pivotGrid.GridLayout.ColumnHeaderCells.Count == 1)
        {
             pivotGrid.GridLayout.ColumnHeaderCells[0].IsExpanded = true;
        }
    }

    You can read more in this article. 

     About your second question this is a thing we are working on and hope to implement this feature in future releases of pivot grid control.