Hi
I'll explain my question with an example.
I have a simple summary with SummaryType.Sum. Let's say I have 2 rows, with values -2, +2. The sum is 0.
When ANY individual value in the sum is NOT zero, I want the Appearance of the summary to change (ie: Backcolor=Yellow).I can't use the sum to figure out when to change the Appearance. (In this example, the sum is 0, even though there are individual values that are non-zero.)I have tried to use SummaryValueChanged, but can't figure out how to access the individual values that make up the sum.I have tried to use a CustomSummaryCalculator (since I can access the individual values), but I can't figure out the right property to change the Appearance. I tried the summarySettings.Appearance, but nothing changed.
Any ideas?Thanks!
If you use SummaryValueChanged, you can get the rows that are associated with the summary by using:
e.SummaryValue.ParentRows
I'm not sure why the SummarySettings.Appearance does not work in the ICustomSummaryCalculator. It should work. But you would really want to use the SummaryValue.Appearance, anyway, and I'm not sure that's exposed by the interface.
Hi Mike Thanks for the reply, and sorry about the delay.
I should have mentioned I tried what you mentioned originally, and it worked when I did 1 level of grouping. (I would access the ParentRows, and go through each Cell to retrieve the individual values.)But if I add another level of grouping (group by 2 or more columns), then access the ParentRows in SummaryValueChanged, ParentRows are of type UltraGridGroupByRow, and the Cells collection is null. I can't figure out what property I then need to access to get hold of the right Row collection or Cell collection to retrieve the individual cell values.
Any ideas?Thanks
Mike