HI All,
I want to show the sum of band1 cellvalue as band0 cellvalue.
for example:
Band0 -> col1 col2 col3
1 2 8 (sum of 2 rows value of col3)
Band1 -> col1 col2 col3
1 2 4
any pointers please.
With Thanks & Regards
Amjath
Hi Mitko,
still Im facing issues with calcmanager in excel export aftering using useexcelformula in excelexporter as well.
for few columns am gettting object reference error.
please help me on this.
Hello, Amjath
I am just checking about the progress of your issue. If you require my further assistance on this matter don't hesitate to ask me.
Thank you for using Infragistics Components.
Hello Amjath,
One thing you could do in your case, is to use UltraCalcManager to assign a formula which calculates the sum of the cells in the parent band. To do so you need to add the UltraCalcManager to your form and then add the following line:
ultraGrid1.DisplayLayout.Bands[1].Columns["SumQuantityColumn"].Formula = "sum([../../Quantity(*)])";
For more information on UltraCalcManager visit the following link:
http://help.infragistics.com/NetAdvantage/WinForms/2013.1/CLR4.0/?page=WinCalcManager.html
And please pay close attention to the “WinCalcManager Formula and Reference Guide”:
http://help.infragistics.com/Help/NetAdvantage/WinForms/2013.1/CLR4.0/html/WinCalcManager_Formula_and_Reference_Guide.html
I have attached a sample which demonstrates this approach. If you have any additional questions don’t hesitate to ask them.