Changing the decimal symbol and thousands separater

Hi,

I think you will want to create your summary on the "real" column, so that it can have the correct total and then you need to change the display to show the correct decimal and separator.

There are a coupe of ways you could do that:

1) You could create an ICustomSummaryCalculator. This way you can return whatever value you want as the result of your summary. The down side of this approach is that you have to do the calculation of the summary yourself, too - it's all or nothing.

2) You could use a CreationFilter to simply change the Text of whatever UIElement is displaying the summary.

I'd go with approach 2, myself. Here's some quick sample code that I whipped up that does what you want:



        public class MySummaryCreationFilter : IUIElementCreationFilter
        {
            #region IUIElementCreationFilter Members

            public void AfterCreateChildElements(UIElement parent)
            {
                SummaryValueUIElement summaryValueUIElement = parent as SummaryValueUIElement;
                if (summaryValueUIElement != null)
                {
                    TextUIElement textElement = summaryValueUIElement.GetDescendant(typeof(TextUIElement)) as TextUIElement;
                    if (textElement == null)
                    {
                        Debug.Fail("Failed to get a TextUIElement in the SummaryValueUIElement; unexpected");
                        return;
                    }

                    SummaryValue summaryValue = summaryValueUIElement.GetContext(typeof(SummaryValue)) as SummaryValue;
                    if (summaryValue == null)
                    {
                        Debug.Fail("Failed to get SummaryValue from summaryValueUIElement; unexpected");
                        return;
                    }

                    if (summaryValue.SummarySettings.Key == "MySummary")
                        textElement.Text = summaryValue.SummaryText.Replace(".", "X");
                }
            }

            public bool BeforeCreateChildElements(UIElement parent)
            {
                // do nothing. 
                return false;
            }

            #endregion
        }