0 Replies Latest reply on Jul 9, 2009 4:21 AM by bob_ramsey

    help displaying data in advanceddatagrid tree

    bob_ramsey

      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