I am using RadGrid which binds a stored procedure call to 1 DataSet. The first column of the DataSet is "Supervisor" which I have set a grouping on. All of the Supervisors are grouping correctly and works great. However, I would like to add a Footer row to the bottom of each section of Supervisor Groupings. Additionally, I would like to have a summary row for the entire RadGrid at the bottom. I've added the appropriate RadGrid.ShowFooter, RadGrid.MasterTableView.ShowFooter and RadGrid.MasterTableView.ShowGroupFooter values to true.
Finally to my question. For each Supervisor "group" section of data being returned from the stored procedure, I have the Footer summary row with custom calculations performed in the sproc itself. At this point, all I want to do is display the results of that sproc as the Footer. Unfortunately, the data is presumed to be part of the GridDataItems and not a GridFooterItem. How do I configure the sproc and the RadGrid to presume the last row of each "group" is the Footer summary row?
Thanks in advance.
Finally to my question. For each Supervisor "group" section of data being returned from the stored procedure, I have the Footer summary row with custom calculations performed in the sproc itself. At this point, all I want to do is display the results of that sproc as the Footer. Unfortunately, the data is presumed to be part of the GridDataItems and not a GridFooterItem. How do I configure the sproc and the RadGrid to presume the last row of each "group" is the Footer summary row?
Thanks in advance.