Hide some (but not all) group footers

[Michael Yereniuk]

I have two group levels in my grid which I get by adding:

            Me.RadGridView1.MasterTableView.GroupByExpressions.Add("ClientName [Client] Group By ClientID ASC")
            Me.RadGridView1.MasterTableView.GroupByExpressions.Add("JobName [Job] Group By JobID ASC")

I have group footers enabled and I am calculating one of my columns avg total by using the aggregate (avg).  There are two problems here:

1) I am getting a calculated group footer for both clients and jobs. I would like to hide the client group footer so that only the job footer(s) are displayed
2) Even if I wanted to display the 2nd group footer, the total that it gives me is incorrect. It should be an average of all of the job calculated group totals, but instead, on further investigation I see that it is taking an average of only the last record in each job, and doing an average (weird!).

That last point may or may not be a bug, as I am just learning how to use this control.. Either way, I would like to only display the one group total footer.

Can anyone help?

[Yavor]

Hello Michael,

Attached to this message, you will find a sample application, which handles a functionality close to the one that you mentioned.
I hope this helps.

Regards,
Yavor
the Telerik team

Instantly find answers to your questions at the new Telerik Support Center

[gemr1423]

In the example, if I have a GroupFooterTemplate and I want in a group show some data and other data in the other group. How do I identify which group corresponds to each footer?

[Kostadin]

Hi,

There is a several way which could serve your needs. A possible solution is to use the GroupIndex of the corresponding footer item.

footerItem.GroupIndex

Another approach is to compare the cell value by using the column's UniqueName.

footerItem["ColumnUniqueName"].Text

You could also get the GroupHeader items and use the aforementioned method to get the needed information from them.

Regards,
Kostadin
Telerik