Hi Plamen,

Here is something else I noticed:

When I comment out tree expansion code and hiding totals code in LayoutLoaded event, then the scrolling seems fine. Although I can't seem to  expand the Date Hierarchy Row.

Is there a better event to expand tree and hide totals?

private void PivotGrid_LayoutLoaded(object sender, EventArgs e)
        {
            // Turn off col totals
            foreach (PivotDataColumn col in pivotGrid.DataColumns)
            {
                if (col.IsTotal)
                    col.IsVisible = false;
            }

            // Turn off row totals
            foreach (PivotDataRow row in pivotGrid.DataRows)
            {
                if (row.IsTotal)
                    row.IsVisible = false;
            }
           
            // Expand Column Hierarchy
            foreach (PivotHeaderCell cell in pivotGrid.GridLayout.ColumnHeaderCells)
            {
                if (cell.IsToggleVisible && cell.IsExpanded == false)
                {
                    cell.IsExpanded = true;
                    return;
                }
            }
            // Expand Row Hierarchy
           
            foreach (PivotHeaderCell cell in pivotGrid.GridLayout.RowHeaderCells)
            {
                if (cell.IsToggleVisible && cell.IsExpanded == false)
                {
                    cell.IsExpanded = true;
                    return;
                }
            }
          
        }

Thanks

Sangeetha

Thanks

Sangeetha

Hi Plamen,

I modified the Pivot Grid's FlatDataSource as follows:

FlatDataSource fds = pivotGrid.DataSource as FlatDataSource;

                Type t = fds.ItemsSource.GetType();
                counter = 0;
                IEnumerator enumerator = fds.ItemsSource.GetEnumerator();
                while (enumerator.MoveNext())
                {
                    Type type = enumerator.Current.GetType();

                    string indexName = type.GetProperty("Index Name").GetValue(enumerator.Current, null) as string;
                    if (indexName.Equals(selectedIndex))
                    {
                        double dval = 0;
                        try
                        {
                            object oval = type.GetProperty(selectedValueColumn).GetValue(enumerator.Current, null);
                            dval = double.Parse(oval.ToString());
                        }
                        catch (Exception ex)
                        {
                        }
                        type.GetProperty(selectedValueColumn).SetValue(enumerator.Current, dval + shift + (step * counter++), null);

                    }
                }

It seems to sometimes refresh it, but not always unless I Refresh.

Also noticed that this is not the cause for the scrollbar not showing the entire contents of the grid.

Thanks

Sangeetha