iSeller Commerce
iSeller POS Retail
iSeller POS F&B
iSeller POS Express
Crosslight
WebUI
ClientUI
What's New
Download Trial
Web Solution
Mobile Solution
Enterprise Solution
Custom Development
Blog
Community
Latest Development Blogs
ForumPostTopic
Browse By Tag
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!
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(); } }
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?
In your scenario, the calculation must be done on the datasource. The provided WebGrid information will not be sufficient for the scenario.
or
Choose this if you're already a member of Intersoft Community Forum. You can link your OpenID account to your existing Intersoft Social ID.
Choose this if you don't have an Intersoft account yet. Your authenticated OpenID will be automatically linked to your new Intersoft account.
Enter your Wordpress Blogname