Skip to Content
author's profile photo Former Member
Former Member

How to use the Combo Box In MAtrix Colums

HI Experts,

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

Regards And Thanks,

M.Thippa Reddy

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Nov 11, 2008 at 04:38 AM

    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...

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 11, 2008 at 04:44 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.