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?