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 Boris/Mike,
Apologies for delay in response....
I've attached the sample project as requested by Boris, please let me know if you need any additional details from me!
Thank you for all your support!
Hello vbalingula,
I am checking about the progress of this issue. Please let me know If you need any further assistance on this.
Do you have an UltraCalcManager on the form?
Could you please attach if possible a small sample project with your scenario and I will try to make this to work for you?
Hi Mike,
Sorry, I was trying with SummaryType.Sum. When I changed to below code summary grid total dispaly has blank.
Band0.Summaries.Add("Total" + cnt, SummaryType.Formula, Band0.Columns[COL + cnt], SummaryPosition.UseSummaryPositionColumn);Band0.Summaries["Total" + cnt].Formula = "sum(" + COL + cnt + ")";Band0.Summaries["Total" + cnt].SummaryDisplayArea = SummaryDisplayAreas.BottomFixed;