Intersoft Community - WebGrid Enterprise - Overwrite GroupRowInfoText?

Overwrite GroupRowInfoText?

yudi — Wed, 24 Feb 2010 02:25:53 GMT

... but I can only overwrite the GroupRowInfoText for the first cell e.row.cells(0).GroupRowInfoText. Is this even possible?...

Group row header is a row with a single cell. You will not be able to access column n of group row header since it only contains a single cell.

... We're trying to put the group totals at the header row instead of the footer row...

If you wish to put the group total at group row header rather than in group footer row, you can specify the group row info format with the built-in aggregate function. Example:

GroupRowInfoFormat="[value] - Total Orders: [count] items. Average Freight: [avg(Freight)]"

For more detail, please check “DisplayAggregateinGroupHeader.aspx” sample file in WebGridSamples project.

If you have different scenario, could you please enclose a screenshot (as attachment) that shows the expected result (the location where the group total expected to appear)?

Overwrite GroupRowInfoText?

pmdaniel — Tue, 23 Feb 2010 17:54:42 GMT

I am trying to write a value into a group header for a column that is not the first column in the group header. I can't get access to any column other than the first one. In the case below, I want to total mMarketValue which is the 8th column in the grid, but I can only overwrite the GroupRowInfoText for the first cell e.row.cells(0).GroupRowInfoText. Is this even possible? We're trying to put the group totals at the header row instead of the footer row. I'm close, if only I can set header values for each column.

Select Case e.Row.Type Case RowType.GroupHeader For Each r As WebGridRow In e.Row.Children If r.Type = RowType.Record Then

mkt += CType(r.Cells.GetNamedItem("mMarketValue").Value, Double)

colPosition = r.Cells.GetNamedItem("mMarketValue").Position

"mMarketValue").Position

End If Next r

e.Row.Cells(colPosition).GroupRowInfoText = "testing: " & mkt

"testing: " & mktEnd Select