Grid Page Total + DataSource Total

[Jako]

Hi there

I have a total column on one of my grid columns, by using the following code:

applicationValueTotal += Double.Parse(dataItem["ApplicationValue"].Text);
.
.
.
GridFooterItem footerItem = (GridFooterItem)e.Item;
footerItem["ApplicationValue"].Text = "R " + applicationValueTotal;

This works great, but it only gives me the total of the current "visible" records.

I want it to show me the results of the whole dataset at that point and then a sub total for the current visible records.
I also use filters so basically I would like the following:

for example a total of 50 records, 10 per page
full dataset on first page load: sub total = applicationValueTotal Grand Total = 50 records' applicationValue

filter applied: sub total = applicationValueTotal Grand Total = x records returned' applicationValue

I can't query this directly out of the database as client side filters might be applied.

Any ideas?

[Eyup]

Hi Jako,

You can use RadGrid footer's default aggregates as demonstrated in this demo:
Grid / Footer Aggregates

I have attached a sample RadGrid page where I implemented the desired scenario. Please give it a look and try to apply this approach to your own project.

Greetings,
Eyup
the Telerik team

[Jako]

Hi Eyup

Thanks, it works just as expected.