Hi,
I have a ultragrid that has a summary row. I also implemented hide/unhide row functionality as part of requirement. Now here the issue - when i hide the rows on gird it also affecting the summary row at the bottom i.e. .Sum is ignoring the values of hidden row its only calculating what’s visible on grid.
I also tried implementing ICustomSummaryCalculator but there also i'm not getting reference of hidden row!
Is there any setting/property to through i can tell summary field to consider hidden rows for sum?
Thanks
Venkatesh
Hi Venkatesh,
You could use a Formula summary instead of the built-in summary types.
Place an UltraCalcManager component on the form with the grid in order to use formulas.
Thanks Mike, for your quick response!
While using CalcManager i landed into another issue :( - On my screen i've dynamic columns (i mean "Price0", "Price1" etc) -- How do i specify column in formula?
e.Layout.Bands[0].Columns["ColName"].Formula = "10 * [Col2]";
andalso I want formula to calculate the sum of same column.