Showing results for 
Search instead for 
Did you mean: 

Matrix not updating in SBO 2004

Former Member
0 Kudos


I have a matrix with a DBDatasource tied to it. I have a total column at the end of the matrix which I want to update with the total for that line. This doesn't seem to be working. I am running this on the lost_focus event.

I have included the code below, can anyone suggest why it may not be updating please ?

Regards Andy

            For lc = 1 To nodays
              tot = CCur(tot + Val(omatrix.Columns(lc).Cells(pVal.Row).Specific.String))
            omatrix.GetLineData (pVal.Row)
            oform.DataSources.DBDataSources(0).SetValue "u_total", pVal.Row - 1, tot
            omatrix.SetLineData (pVal.Row)

View Entire Topic
Active Contributor
0 Kudos

Hi Paul,

To "Add" values to your matrix - which you are not pulling from the DB - you have to specify an user data source. Thus add the user datasource to your totals column. Now run your code and calc the totals for each row - write the value to your column AND becuase you have the user datasource tied to the column -> the value s will be displayed!