[flexcoders] best way to summarize and display data

[Ramsey, Robert L]

Hi,

I'm trying to think of the best way to let a user summarize and display data.  
The data is in xml format and looks like this(simplified some):


<orgs>
                <org>
                                <name>Foo</name>
                                <date>01-01-2009</date>
                                <user>Alice</user>
                </org>
                <org>
                                <name>Foo</name>
                                <date>01-02-2009</date>
                                <user>Alice</user>
                </org>
                <org>
                                <name>Foo</name>
                                <date>01-01-2009</date>
                                <user>Bob</user>
                </org>
                <org>
                                <name>Bar</name>
                                <date>01-01-2009</date>
                                <user>George</user>
                </org>
                <org>
                                <name>Bar</name>
                                <date>01-02-2009</date>
                                <user>Alice</user>
                </org>
                <org>
                                <name>Bar</name>
                                <date>01-03-2009</date>
                                <user>Alice</user>
                </org>
                <org>
                                <name>Foo</name>
                                <date>01-05-2009</date>
                                <user>Eve</user>
                </org>
                <org>
                                <name>Spaz</name>
                                <date>01-01-2009</date>
                                <user>Eve</user>
                </org>
</orgs>

What I think I want is a four column advanceddatagrid in tree view.  The first 
column would contain the "group"  and the other three would just be name, date, 
user.  There would be three buttons, each with a different grouping.  So if I 
click the Name button, it would look something like this:

Group   Name    Date                      User
Foo
>              Foo        01-01-2009          Alice
                Foo        01-02-2009          Alice
                Foo        01-01-2009          Bob
                Foo        01-05-2009          Eve
Bar
>              Bar         01-01-2009          George
                Bar         01-02-2009          Alice
                Bar         01-03-2009          Alice
Spaz
>              Spaz       01-01-2009          Eve


If the user clicked the Date button it would look like:
Group                   Name    Date                      User
01-01-2009
>                              Foo        01-01-2009          Alice
                                Foo        01-01-2009          Bob
                                Bar         01-01-2009          George
                                Spaz       01-01-2009          Eve


And so forth.  Each grouping would be collapsible since it is in tree view.  
Does anyone have any pointers on the best way to do this?

Thanks,

Bob