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
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.
Thanks Mike,
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?
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