Intersoft Community - WebGrid Enterprise - Group totals across pages?

Group totals across pages?

Glayaar — Tue, 03 Nov 2009 22:07:36 GMT

In your scenario, the calculation must be done on the datasource. The provided WebGrid information will not be sufficient for the scenario.

Group totals across pages?

pmdaniel — Tue, 03 Nov 2009 08:07:26 GMT

Thanks. I tried that, but I can't access all the rows for the group. When I code e.Rows in the CustomAggregate event stated above, it only brings back the rows on the current page. I assume I'll have to go back to the dataset to perform my calcs instead of depending on the grid? I can grab my grooupby value and use it to sum up my columns in the dataset? Is there an easier/cleaner way I'm missing by using this customaggregate?

Group totals across pages?

Glayaar — Mon, 02 Nov 2009 21:06:16 GMT

You could use the Custom AggegrateFunction property. This way you could handle the aggegrate function and return the total value that will comply with your scenario. The event handler will be handled by CustomAggegrate server side event. Here is the snippet:

protected void WebGrid1_CustomAggregate(object sender, ISNet.WebUI.WebGrid.CustomAggregateArgs e)
{
    if (e.Column.Name == [ColumnName])
    {
        //Get the GroupTotal using custom function
        e.AggregateResult = GetTotal();
    }
}

Group totals across pages?

pmdaniel — Mon, 02 Nov 2009 11:32:40 GMT

We have the latest grid control and are looking to see if it is possible to have the entire group total in the group footer on a page when the group crosses multiple pages? If the group starts and ends on 1 page, the group total works, but if it goes more than 1 page, the group total shows the total just for the page. Can it be adjusted to show the accumulated total for the group instead of the rows being displayed on the page?

Thanks in advance!