Hi,
Can some body provide me a summary row example
But I got something like this.
How can I avoid that Sum = 0. I want just 0 instead of sum = 0.
Please provide me some suggestions.
Use the DisplayFormat property on the SummarySettings.
SummarySettings summarySettings = band.Summaries.Add(...);summarySettings.DisplayFormat = "{0}";
I need to display two summary fields Total Man Hours and Total LaborCost within the same grid (like the one I showed in figure).
There's no built-in way to have a summary that displays across two columns like you have here. But you could add an addition summary to the second column in each group and it will show up in the first summary.
In other words, you add two summaries to the band, both of which are using the same SummaryPositionColumn and they will display one under the other.
I am able to display two summary rows one after the another.
But I also need a third summary row based on the values in top two summary rows.
How can I do that?
Also Is there any way to display a blank row between summary rows??
Let me know
nag4054 said: But I also need a third summary row based on the values in top two summary rows. How can I do that?
You can add as many summaries as you want to a single column. If you need a summary whose values depends on two other summaries, then you have two options:
1) You can create a summary using an ICustomSummaryCalculator which you write code for.
2) You can use the UltraCalcManager. In which case, you need to make sure that both of the other two summaries have a Key. Then you can add a Formula summary for the third summary and the formula can refer to the other two summaries by key.
My summary has a key by name 'Day1SRHrs'
I have another summary and I set the formula for that summary as
RegFinalHrs.Formula = "[Day1SRHrs] + 2"
I am getting 'invalid or not found reference' error ( it is showing !REF in the summary field)
Is the syntax wrong. Let me know
Sorry, I always forget there's a little caveat here. Since it's possible for a summary and a column in a band to have the same key, you have to distinguish that you want a summary reference and not a column reference using parens, like this:
RegFinalHrs.Formula = "[Day1SRHrs()] + 2"