Hello PPilev,

Using the latest 2011.2 controls.  Here is the method in the user control to convert the DataTable to an Ilist for the data selector and pivot grid:

public void SetFlatDatasource(DataTable dt)
{
    DynamicTypeBuilder typeBuilder = new DynamicTypeBuilder
    {
        DynamicAssemblyName = "MyAssembly",
        DynamicTypeName = "Pane"
    };

    IList properties = new List();

    foreach (DataColumn column in dt.Columns)
    {
        DynamicTypePropertyInfo propertyInfo = new DynamicTypePropertyInfo
        {
            PropertyName = column.ColumnName,
            PropertyType = column.DataType
        };
        properties.Add(propertyInfo);
    }

    Type dynamicType = typeBuilder.GenerateType(properties);
    Type listType = typeof(List<>);
    Type genericListType = listType.MakeGenericType(dynamicType);

    IList list = (IList)Activator.CreateInstance(genericListType);

    foreach (DataRow dataRow in dt.Rows)
    {
        object myDynamicInstance = Activator.CreateInstance(dynamicType);

        foreach (DataColumn column in dt.Columns)
        {
            PropertyInfo propertyVal = dynamicType.GetProperty(column.ColumnName);

            if (dataRow[column] != DBNull.Value)
            {
                propertyVal.SetValue(myDynamicInstance, dataRow[column], null);
            }
        }

        list.Add(myDynamicInstance);
    }

    FlatDataSource flatDataSource = new FlatDataSource()
    {
        ItemsSource = list,
        Cube = DataSourceBase.GenerateInitialCube("Pane"),
        // if you know the names of demensions you want to be in rows and columns you can define them here
        Columns = DataSourceBase.GenerateInitialItems("[Columns]"),
        Rows = DataSourceBase.GenerateInitialItems("[Row]"),
        Measures = DataSourceBase.GenerateInitialItems("Value")
    };

    dataSelector.DataSource = flatDataSource;
    pivotGrid.DataSource = flatDataSource;
}

When you say initialization, do you mean the xaml? If yes, how can we post xaml in this forum? I will say it does not contain anything special. AllowCompactLayout is set to True, Height and Width are set to Auto...there is really nothing noteworthy.

Simple question, should this control perform well with a row count of say 2,000 with 8 columns?

Hi JaimeZ,

I’m preparing a WPF sample now and I’m going send it to you soon.

Plamen.

Hi again,
I have attached the WPF version. In the sample all root nodes are expanded by default. Also flat data source now uses a non-generic hierarchy and level descriptors appropriate for dynamic classes and excel scenarios as well.

Regards.
Plamen.

Hi Plamen,

You are the best.  REALLY appreciate your support!  I was able to use your example to finally see my data pre-loaded in the pivot grid, however staying on topic with memory issues, I need to have all of these levels expanded by default.  Users will need to see this view by default else they need to click hundreds if not thousands of expanders...it is not going to happen. 

Ideally, what they want is the first row group level expanded by default, but the expansion of each of these to expand the all of the related remaining sub groups.  In your example this would mean having All Products expanded to see the names and totals of the Categories.  The expansion of one Category should auto-expand of of that Category's Brands and Products.

For Columns, all of the Regions and Distributors should be visible when loaded.

How did you generate this event method?  I copied the method into my code but it is never hit because I do not know how to wire it.  In winforms I am used to auto generating these events from each control's properties window.

private void AreaItems_CollectionChanging

Disregard my question about the event method.  The answer was right in front of my face. Bad morning... Computer troubles delayed me for over two hours.  :)

I should try to think before posting.  :)  

All child nodes should be expanded.  What I would love is to not have totals for Category, Brand and Product where there is only one.  Please tell me this is possible?

Hello Plamen,

Your sample works great.  The only enhancement that would make it perfect would be to not expand child nodes if there is only 1.  This way you do not end up with a bunch of "total" rows for a single Category, Brand, and product.  Product should only be expanded if there is more than 1.  Same for Brand and Category.  Is this an easy tweak?

The good news is after expanding all nodes the memory only hit a maximum of 200,000 kb, so the issue is only with dragging dyamic rows into the grid with no pre-defined data class or heirarchies.

Thanks!