Intersoft Community - WebGrid Enterprise - Grouptotals on group header row instead of footer row

Grouptotals on group header row instead of footer row

yudi — Wed, 02 Jun 2010 16:08:06 GMT

I’d like to add Handy’s information regarding this topic.

I assume that the group totals that are shown in the footer line is the ‘FooterText’ that displays the result of ‘AggregateFunction’ as shown in GroupFooterTotal.aspx (please click here to see the live sample version of GroupFooterTotal.aspx).

If you wish to have the result of ‘AggregateFunction’ displayed in GroupHeader row (have only one line showing the item name and the totals for that item in the corresponding column), then Handy’s approach is the best solution to implement this kind of scenario.

There is another feature of WebGrid that might meet your scenario. it is called ‘GroupRowInfoFormat’.

Although built-in Aggregate Functions are already available in WebGridColumn, you need to enable GroupTotal feature to display the aggregated values. When enabled, a special total row will appear after the group header to display each calculated values of aggregate functions defined in specific WebGridColumn.

With the ‘GroupRowInfoFormat’ feature to display basic aggregate functions in group header, you can display the calculated values without has to enable the GroupTotal feature. This feature is useful when you only need to display a small number of calculated values and therefore reducing unnecessary clutter in the Grid’s user interface.

The format string for new aggregate functions that you can apply in group header:

sum(Column Name)
avg(Column Name)
min(Column Name)
max(Column Name)

Please check the ‘DisplayAggregateinGroupHeader.aspx’ sample (click here to see the live sample version of DisplayAggregateinGroupHeader.aspx) for more detail about the implementation of the feature.

Hope this helps.

Grouptotals on group header row instead of footer row

handy@intersoftpt.com — Wed, 02 Jun 2010 02:18:33 GMT

Hello,

Currently, we don't have that feature. You will need to get the element of group header and write manually the footer in there. I attached a simple sample to show you how to do it.

FYI, the elements could be different with yours because of your different WebGrid structure.
So, It depends on your WebGrid structure.

Regards,
Handy

Grouptotals on group header row instead of footer row

msek — Tue, 01 Jun 2010 21:57:06 GMT

Hi,

We are looking into buying and using WebGrid control and would like to know the following:

When grouping the group totals are shown on a footer line, when collapsed you always see 2 lines.

One line with name of grouped item and second line with totals.

Is it possible to have only one line showing the item name and the totals for that item in the corresponding columns?

Regards,

M Sekha