How to use the Combo Box In MAtrix Colums

[Former Member]

HI Experts,

Good Mornong.How to use the Combo Box In MAtrix Colums?

Regards And Thanks,

M.Thippa Reddy

[Former Member · Accepted solution]

Design a form with matrix in screen painter, After selecting the matrix goto the colum properties. In that there will be TYPE field..In that u select COMBO_BOX....After that u need to give the valid values in XML...

[Former Member]

hi,

loading data in to the combobox on form load.but, it should be done when atleast one row is active.

the values what ever you are inserting in to combo should be less than or eqhal to 100 or 150.if it exceeds beyond that performance issue arises.it takes more time to load all the data.so, it is better to have 100 or less.

oMatrix.AddRow()
RS = Nothing
RS = ocompany.GetBusinessObject(SAPbobsCOM.BoObjectTypes.BoRecordset)
RS.DoQuery("select ItemCode,ItemName from oitm")
oCombo = oMatrix.Columns.Item("ColumnUID").Cells.Item(oMatrix.RowCount).Specific
For i = 1 To RS.RecordCount
      If RS.EoF = False Then
            oCombo.ValidValues.Add(RS.Fields.Item("ItemCode").Value,RS.Fields.Item("ItemName").Value)
            RS.MoveNext()
      End If
Next

the above code is inserting data from database to column combobox.

you can fill combo directly also as shown below.

oCombo.ValidValues.Add("x","1")
oCombo.ValidValues.Add("y","2")
oCombo.ValidValues.Add("z","3")
.
.
oCombo.ValidValues.Add("","")

and what ever the values you are filling into combo should be unique.other wise it shows valid value exists.

regards,

varma