Matrix ColumnSetting.SumType value

[Former Member]

Hi Techies,

In Matrix column sum automatically added by below mentioned code.

eg:Matrix.Columns.Item("colName").ColumnSetting.SumType = SAPbouiCOM.BoColumnSumType.bst_Auto

On clicking the update Button the value in sum column get cleared why?.Screen shot in added here.

Is there any option to get correct value in this field.

Thanks and Regards,

YADAV

[Former Member]

How are you binding this matrix?

[pvsbprasad]

Hi,

Try to  loop the each column and get SUM of the value and assign to the filed.

Regards,

Prasad

[Former Member]

Hi Prasad,

sum field is a automatic cell coming in bottom of each matrix column,sum is automatically calculate the value while entering the values in column.when updating the form the value get cleared.

Thanks and Regards

YADAV

[pvsbprasad]

Hi,

In before action=true andItempressed event and Pva.itemuid=1

write for Loop get each value from cell and make the sum and assign to the matrix column

Matrix.Columns.Item("colName").cells.item(i).specfic.value=total(i.e looping each value sum)

Regards,

Prasad

[Former Member]

hi Prasad,

The cell where i want to print the total is outside the matrix-

In Form Loading function i had written below code for displaying that cell below the column :

Matrix.Columns.Item("colName").ColumnSetting.SumType = SAPbouiCOM.BoColumnSumType.bst_Auto

so we can't loop the rows and put the total in this cell.

Thanks and Regards,

YADAV

[pvsbprasad]

Hi,

As discussed above

As the data is not getting filed

In before action=true and Itempressed event and Pval.itemuid=1

write for Loop get each value from cell and make the sum and assign to the matrix column

objform.items.item("ITEMUID").specfic.value=total(i.e looping each value sum)

Regards,

Prasad