OK, here is my situation. Let's say I have a UltraGrid with one group by column. I then have a column named "Folder" where every value will always be the same for the group by values. I have a bunch of summaries that I display in the group by row. I would like to display a summary in the group by row for this "Folder" column where all values are the same. I really cannot think of an easy way to tackle this problem, but perhaps I'm overlooking something very simple. Here is an example of my grid, the numbers surrounded in asteriks are what I would like to display for the smmary values. Any ideas?
Folder
Group 1 *1*
1
Group 2 *2*
2
I actually had the solution all along and a combination of exhaustion/laziness prevented me from seeing my error (I had specified different columns for source and position).
SummarySettings s = band.Summaries.Add("FolderName", SummaryType.Custom, new CustomSummary(), band.Columns["FolderName"], SummaryPosition.UseSummaryPositionColumn, band.Columns["FolderName"]);
My custom summary class simply stores the last value that came in to it and continues storing it until a different value comes in at which point it makes it string.Empty. This has the effect of displaying summaries as empty when all of the corresponding cells are not equal.
Already tried formula, it failed. Didn't think of min and max but yes that does work. The level of control to the user is very fine, however, and it may not always be that there is a grouping where Folder will be unique. I have started looking at ICustomSummaryCalculator to see if it would work. Thank you for you help.
A Min, Max or Formula based summary would probably work. Formula = "[Folder]"
Nick