RadGrid Hierarchical or Grouped with Orphan Records

[Dan]

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

[Dan]

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

[Vasil]

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