This is a migrated thread and some comments may be shown as answers.

RadGrid Hierarchical or Grouped with Orphan Records

2 Answers 44 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Dan
Top achievements
Rank 1
Dan asked on 22 Oct 2012, 08:50 PM
Hi,

We want to have a hierarchical or grouped radgrid, but also allow individual records to be displayed at any level.

Each record is a document which is in a fund, but there can also be documents outside the fund, relating to the whole entity.

For example:
   Doc Title                                            Doc Type    Imported By                        Imported Date        Belongs To
> Entity A          
  EntityASpecialOmnibus.pdf Generic Robert Frost 8/24/2010 8:24:34 AM
  > Fund 1          
    FundDetail.pdf Generic Arthur Cunningham 7/16/2010 5:35:43 PM
    GreatNeckIncidentals.txt Generic Arthur Cunningham 7/16/2010 5:39:35 PM
    testdoc.pdf Doc admin1 1/24/2011 12:34:43 PM William Yeats
    testdoc2.pdf Doc admin1 1/24/2011 12:34:43 PM William Yeats
    testdoc3.pdf Doc admin1 1/24/2011 12:34:43 PM William Yeats
    testdoc6.pdf Doc admin1 1/24/2011 12:34:43 PM William Yeats
  > Fund 2            
    FederalAction.doc Generic Arthur Cunningham 7/16/2010 5:35:43 PM
    Statereturn.pdf Tax admin1 7/16/2010 5:39:35 PM William Yeats
    FederalReturn.pdf Tax admin1 1/24/2011 12:34:43 PM William Yeats
    OhioK1G.pdf K-1G admin1 1/24/2011 12:34:43 PM William Yeats

Is this possible in RadGrid?

Thanks

Daniel

2 Answers, 1 is accepted

Sort by
0
Dan
Top achievements
Rank 1
answered on 23 Oct 2012, 04:30 PM
Just a bit more detail: we have a dataset returning with Tier1Name and Tier2Name as fields. When the Tier1Name is EntityA, and Tier2Name is Fund1 or Fund2, we can of course just group by Tier1Name and Tier2Name, and basically get the grid that is displayed in my first post.

The problem comes up when Tier2Name is NULL - in this case, we want the document to be recognized as a Tier1 item, and be outside any Tier2 indentation, as you can see visualized in the first record row in the example mock-up in my first post. Is this functionality possible in RadGrid? Is there a way to hack it if not?

Urgently looking forward to a response,

Thanks so much

Daniel
0
Vasil
Telerik team
answered on 25 Oct 2012, 10:56 AM
Hello Daniel,

You can't directly bind the dataset with these fields directly to the grid, and to get the required hierarchy structure.
You could try to create two tables, that to be used in hierarchy, first one will contain all tier1 and all tier2 if Tier2Name==null. Second table to contain the rest of Tier2. Then bind these tables to the grid.

All the best,
Vasil
the Telerik team
If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.
Tags
Grid
Asked by
Dan
Top achievements
Rank 1
Answers by
Dan
Top achievements
Rank 1
Vasil
Telerik team
Share this question
or