I try to fill-in a matrix using a recordset and userdatasource.
here is a part of codes:
For i As Integer = 1 To rs.RecordCount
oMatrix.AddRow(i)
oUDSCardCode.ValueEx = rs.Fields.Item("CardCode").Value
oUDSCardName.ValueEx = rs.Fields.Item("CardName").Value
oUDSItemCode.ValueEx = rs.Fields.Item("ItemCode").Value
oUDSItemName.ValueEx = rs.Fields.Item("ItemName").Value
oMatrix.SetLineData(i)
oMatrix.FlushToDataSource()
rs.MoveNext()
Next i
my problem is, there is only 3 records in the recordset:
i.e.
AAACode AAAName AAAItem AAADesc
BBBCode BBBName BBBItem BBBDesc
CCCCode CCCName CCCItem CCCDesc
but the Matrix shows:
AAACode AAAName AAAItem AAADesc
BBBCode BBBName BBBItem BBBDesc
BBBCode BBBName BBBItem BBBDesc
CCCCode CCCName CCCItem CCCDesc
CCCCode CCCName CCCItem CCCDesc
CCCCode CCCName CCCItem CCCDesc
Any ideas?
Thanks