I am coding a business forecast. Several columns will have summaries (Price, Qtr 1, Qtr 2, Qtr 3, Qtr 4, Fiscal Year, etc).
I need 8 separate summary lines to be positioned at the bottom of the grid.
I cannot group the grid rows by status.
Your great advice is appreciated.
Thanks!
Hi Jeff,
I don't understand what you are asking. Can you be more specific? Which part of this is giving you trouble?
Mike,
Here is a sample:
Looks like you might want to add a summary of type custom for each of those. Write a routine that sums only the numbers for a particular status. Believe there is an example of a custom summary in the help but it may be in a KB article.
Nick
I appreciate all the support. I will phrase my questions better in the future. The summary stacking feature is just what I needed. I kinda wonder why finding this stuff is so difficult (perhaps it's me). Again, thanks for your quick responses and geat help. Keep up the good work.
Yeah, when you add the summary in code, the Summaries.Add method lets you specify a column under which to position the summary. If you add more then one summary under the same column, they will stack just as you have it here.
Yes absolutely. Same as if you choose to do a min,max,sum and count all on the same column it will work. The trickiest part for you will be the description of the level although since you have a nice string column already that won't be very difficult. Just set the summary on it also with a format of "Your column description here" for the description summary.
I appreciate the feedback, but perhaps I have not phrased the question correctly.
I can handle the calculations; that is not the issue.
Can the grid display multiple summary rows, and position the values under specific columns?
Thanks,
Jeff Keryk
Yeah, I think Nick is right. It looks like you want to do more complex summaries than the built-in functionality can handle. So you will need to create your own ICustomSummaryCalculator classes to handle the calculations.