Summary (Totalling)

[Bernard Herrok]

Hi,

I''m trying to add a summary row in my grid. But it doesn''t seem to work out the totals.

If i change the format to Average, Minimum, Maximum or Count, it works properly.

But not with totals.
It sometimes show "1200 Records" or however many records i''ve got on the dataset.

Is something wrong with the code bellow?

sd0.Name = "2002/2003_Total"
sd0.DataMember = "2002/2003_Total"
sd0.DisplayColumn = "2002/2003_Total"
sd0.Format = "{Total}"
sd0.SummaryType = SummaryType.DoubleAggregate
Dim grd As GridSummaryRowDescriptor = New GridSummaryRowDescriptor("SummaryRow", "Total", sd0)

MarketingDG.TableDescriptor.SummaryRows.Add(grd)

Thanks,
Bernard Herrok

[Administrator]

Instead of {Total}, try using {Sum}.

sd0.Format = "{Sum}"

[Bernard Herrok]

Please have a look at the attached image. Looks like there''s a margin set for the summary row title. Because depending how low you go in the levels, the title get cut. How do I get it to display the full title? Thanks, summary row_7092.zip