Self-referencing Hierarchy - Limit duplication of Data

[John]

Is there a way to limit the duplication of the data displayed?  Currently it shows every line that is returned on the first level and re-shows the line for every item it reports to in the sub-levels.  I used the self-referencing Hierarchy example in the demo to create it.

[Daniel]

Hello John,

Our online demo uses filtering to avoid this behavior:

Sample code:

public void Page_Load(object sender, EventArgs e)
{
    if (Assembly.GetAssembly(typeof(ScriptManager)).FullName.IndexOf("3.5") != -1 || Assembly.GetAssembly(typeof(ScriptManager)).FullName.IndexOf("4.0") != 1)
    {
        RadGrid1.MasterTableView.FilterExpression = @"it[""ReportsTo""] = Convert.DBNull";
    }
    else
    {
        RadGrid1.MasterTableView.FilterExpression = "ReportsTo IS NULL";
    }
}

Best regards,
Daniel
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.

[John]

I had taken that section out because it was not returning anything because my top level item was using a parent/reportto of 0 not NULL.  I changed it to NULL and it worked.  Thanks for the help.