Is it possible to change the text before the summary value? Currently it will say "Summaries for [column name]". I'd like to tweak it to say something else if possible.
Also how can I change the background color for the summary value cell? It is currenlty a light yellow color. If I change the BackColor nothing happens.
cramsundar said:Is it possible to change the text before the summary value? Currently it will say "Summaries for [column name]". I'd like to tweak it to say something else if possible.
Yes, you can do this with the DisplayFormat property on the SummarySettings.
cramsundar said:Also how can I change the background color for the summary value cell? It is currenlty a light yellow color. If I change the BackColor nothing happens.
Yes, you can use the SummarySettings.Appearance.BackColor. I'm not sure why this is not working for you. Perhaps you are setting the BackColor of the wrong object, but you weren't specific about what BackColor you are setting, so I can only guess.
Thanks for the reply.
I use the following code to change that value that appears for the summary value, e.SummaryValue.SummarySettings.DisplayFormat = "{0:F01}";. However if possible I'd like the change the text where is says "Summaries For". The line of code I used changes the value from "Sum 10.02" to just "10.0".
For the SummarySettings.Appearance.BackColor, do I have to set that at run time or can I change that at design time?
The brackets are a replacement code within the format string. So the brackets are replaced by the value of the summary. Anything outside the brackets will be displayed as is.
So you could use a format like "My summary is {0:F01} and that's good"