Multi row selection in grouped grid (or hierarchical grid)

[jan]

Hi,

I need to implement several level nested hierarchy with possibility to check (or select) multiple rows, but also whole groups or sub-groups of rows (let say that for rows of orders for customers from different countries I need to group every orders of each customer together and every customers from each country together and then be able to select multiple orders – one by one or every for selected customers or every for selected country – so that after selecting one subgroup, each row of this sub-group will be selected).

I would like to use grouping for this – but I was not able to simply add check-boxes in header lines.

<telerik:GridGroupByExpression>

        <SelectFields>

            <telerik:GridGroupByField FieldName="countryName" HeaderText=" <input type='checkbox' onClick='CountryRowSelecting()'> " />

        </SelectFields>

        <GroupByFields>

            <telerik:GridGroupByField FieldName="countryId" SortOrder="Descending" HeaderText="Country" />

        </GroupByFields>

</telerik:GridGroupByExpression>

<telerik:GridGroupByExpression>

        <SelectFields>

            <telerik:GridGroupByField FieldName="customerName" HeaderText=" <input type='checkbox' onClick='CustomerRowSelecting()'> " />

        </SelectFields>

        <GroupByFields>

            <telerik:GridGroupByField FieldName="customerId" SortOrder="Descending" HeaderText="Customer" />

        </GroupByFields>

</telerik:GridGroupByExpression>

But then I was not able to properly handle these events, I think there should be some easier way.

I was also trying hierarchical grid (but I would like it with grouping more), but there with multi-rows grouping, when I selected whole category, just one sub-level subcategories was selected (but I need it for each level- e.g. after selecting some country, each order for each customer from this country would be selected).

Does radgrid somehow enable this desired behaving?

Thanks

Jan

[Yavor]

Hi jan,

The functionality can most easily be achieved in a hierachical structure. As a starting point, you can use the following example, which shows how to access the different elements of the hierarchy. A similar approach can be used to achieve the effect of selecting the inner level(s) by selecting the master record. Also, attached to this message, is a small working application, which handles a very similar functionality.
I hope this helps.

Greetings,
Yavor
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.

[Le]

Hi,
I got the issue when I add groupby expression in codebehind. It does not have multi-rows grouping, but it show the same row header
    + Column1;Column2;Column3
I need groupby expression like that
    + Column1
          + Column2
                 + Column3
Plz, Help me!
Best regards,

[Shinu]

Hello Le,

You would have to add seperate expressions to your GroupByExpressions collection to achieve the required. Check out the code below :

c#:

        //First expression
        GridGroupByExpression expression1 = new GridGroupByExpression();
        GridGroupByField gridGroupByField1 = new GridGroupByField();

        gridGroupByField1 = new GridGroupByField();
        gridGroupByField1.FieldName = "FirstName";
        gridGroupByField1.HeaderText = "FirstName";
        gridGroupByField1.FormatString = "<strong>{0}</strong>";
        expression1.SelectFields.Add(gridGroupByField1);

        gridGroupByField1 = new GridGroupByField();
        gridGroupByField1.FieldName = "FirstName";
        expression1.GroupByFields.Add(gridGroupByField1);

        //Second expression
        GridGroupByExpression expression2 = new GridGroupByExpression();
        GridGroupByField gridGroupByField3 = new GridGroupByField();

        gridGroupByField3 = new GridGroupByField();
        gridGroupByField3.FieldName = "PlaceFrom";
        gridGroupByField3.HeaderText = "PlaceFrom";
        gridGroupByField3.FormatString = "<strong>{0}</strong>";
        expression2.SelectFields.Add(gridGroupByField3);

        gridGroupByField3 = new GridGroupByField();
        gridGroupByField3.FieldName = "PlaceFrom";
        expression2.GroupByFields.Add(gridGroupByField3);
        // Add the expressions to the GroupByExpressions collection
        RadGrid1.MasterTableView.GroupByExpressions.Add(expression1);
        RadGrid1.MasterTableView.GroupByExpressions.Add(expression2);

Thanks

Shinu.

[Le]

Thanks, I got it.

[Mark]

I am attempting to do something very similar with the hierarchy.   The issue is when the second level in the hierarchy bleeds over onto multiple pages - and I select the top level in the hierarchy (select all), I can't get it to select all for items on subsequent pages (even if they are under this main hierarchy level).   This appears to be a bug.  Does telerik offer a workaround?

[Iana Tsolova]

Hi Mark,

When paging is enable for RadGrid, then the items available in the grid are only these from the current page. Therefore you are able to select only them.
To overcome that issue, you can either disable paging or handle the ItemCommand/PageIndexChanged event to select the items on the new page respectively.

All the best,
Iana
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.