hi , i have this window as attached
first question : can i make a distance between buttons ?
2nd : can make the summary under volume to be expanded under the rest columns ?
3rd : can i make the summary based on a sum or multiply between tow columns ?
yours
Esam Rabba
Hi Esam,
Thank you for posting in our forums.
-To add space between the buttons, you could add a few additional buttons to the buttons collection of the editor, disable them and then make them transparent. This will hide the buttons and it will look like there is blank space between the visible ones
-If you want a summary spanning throughout the whole grid, please enter a new product idea for this from our product ideas site: http://ideas.infragistics.com.
-You can do that by adding UltraClacManager to the form. Then you will need to create a Formula type summary and specify the formula that you want to use for the summary. For a reference for the UltraCalcManager summary formulas, please visit this link:
http://help.infragistics.com/Help/Doc/WinForms/2012.2/CLR4.0/HTML/WinCalcManager_Formula_and_Reference_Guide.html
I have attached a sample demonstrating this suggestions.
I am looking forward to hearing from you.
HI , thank a lot for your reply
for point 1 , 2 its ok
for point 3 i already doing what you write and i'm using it , but the problem in summery its dosn't accept ( sum ([col1] * [col2]) always gives #value response , in excel we can solve it by SUMPRODUCT , is there a work around or direct solution for it ?
thanks a lot
Thank you for the reply.
This happens because you can’t use formulas of the type “[col1] * [col2]” in the summaries. What you could do if you want to have summary doing the same thing as SUMPRODUCT in Excel is to add a new unbound column, with formula “[col1] * [col2]”. Then you can create a sum – “sum([col3])”- summary for this column.
I have modified my sample in order to demonstrate this suggestion.
Please let me know if you have any additional questions.