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