In the grid below I have used Summary by DataType, so the Sequence column and all of the Original and Revised Amount columns are totalled to the bottom of the Grid.
Now, I was able to hide the Sum sign on the Sequence column header, but I actually dont want the Sequence column to have a summary at all. How can I remove this one.
Also, is it possible to remove the 'Sum = ' from each column summary and only have the totalled value.
Can I format the summary? ie halign...I would like these to be right alighed like the columns above them. I also need to format the calculated value to only have 2 digits after the decimal place.
Many thanksJason
Thanks Mike.
Jason McIntosh said: OK. I have gotten rid of the Sum= part as I need to by simply setting DisplayFormat to {0} Now for my next trick. How can I force this numerical value (generally with 4 decimal places) to only show 2 decimal places?
OK. I have gotten rid of the Sum= part as I need to by simply setting DisplayFormat to {0}
Now for my next trick. How can I force this numerical value (generally with 4 decimal places) to only show 2 decimal places?
The DisplayFormat supports any of the numeric formats supported by the data stye of the value. So you could do something like this: "{0:format}" where format is the format string.
Jason McIntosh said:One second question. I am also trying to get rid of the Sum sign on the column header, and I have not been successful.
One second question. I am also trying to get rid of the Sum sign on the column header, and I have not been successful.
If you don't want the summary button on the column header, then you should not turn on AllowRowSummaries. You can still create summaries in code, this property controls whether the UI for summaries is available to the user.
Thanks Mike,
One second question. I am also trying to get rid of the Sum sign on the column header, and I have not been successful. The properties are all greyed out and unable to be changed:
I was thinking of just changing the size to 0,0, but it does not look like that is an option.
Any ideas on both?
CheersJason
Jason,
You can control what columns show Summaries with the AllowRowSummaries property off the Column object. If you get access to the summaries object you can change it's appearance and it's text format as well. The documentaion link has a code snippet that shows this.
Hi Jason,
If you don't want the column to have a summary, then don't add one. The grid isn't creating these summaries, you must be doing it in your code somewhere. Maybe you are loading a layout into your grid that has this summary defined?
To remove the "Sum=", you need to set the DisplayFormat on the SummarySettings. This is the object that is returned from the Summaries.Add method in code. This is also the object that would allow to to set appearances or format your summary.