cancel
Showing results for 
Search instead for 
Did you mean: 

Merge 2 cells of a Row in Grid/Matrix

Former Member
0 Kudos

Hello,

I want to merge 2 cells of a row in Matrix/Grid. How can i achieve this functionality

Kindly suggest me some idea.

Thanks & Regards

Sandesh Mittal

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hello,

This is not supported in Matrix / Grid

Regards,

J

Former Member
0 Kudos

Hello,

I agree what you have told.But if i make a row as Text type (same as our Transaction Documents) than we achieve this functionality. But again problem is how we can make a row as TEXT.

Thanks & Regards

Sandesh Mittal

Former Member
0 Kudos

Hello,

There are several possibilites,

where is an example of Matrix loaded from datatable, merging 2 fields (cardcode and cardname) in SQL

Dim oForm As SAPbouiCOM.Form = sbo_application.Forms.Add("MATRIXTEST")
        oForm.Visible = True
        oForm.Width = 300
        oForm.Height = 400

        oForm.DataSources.DataTables.Add("oMatrixDT")
        oForm.DataSources.DataTables.Item("oMatrixDT").Clear()
        Dim sSQL As String = "SELECT T0.CardCode +space(0) + T0.cardname as COL1, T0.DocEntry, T0.NumAtCard, T0.DocDate FROM OQUT T0 WHERE T0.DocStatus = 'O' ORDER BY T0.DocNum"
        oForm.DataSources.DataTables.Item("oMatrixDT").ExecuteQuery(sSQL)

        Dim oItem As SAPbouiCOM.Item = oForm.Items.Add("oMTX", SAPbouiCOM.BoFormItemTypes.it_MATRIX)
        oItem.Top = 10
        oItem.Left = 10
        oItem.Width = oForm.Width - 20
        oItem.Height = oForm.Height - 100

        Dim oMatrix As SAPbouiCOM.Matrix = oItem.Specific

        Dim oColumn As SAPbouiCOM.Column = oMatrix.Columns.Add("#", SAPbouiCOM.BoFormItemTypes.it_EDIT)
        oColumn.TitleObject.Caption = "#"
        oColumn = oMatrix.Columns.Add("1", SAPbouiCOM.BoFormItemTypes.it_EDIT)
        oColumn.DataBind.Bind("oMatrixDT", "Col1")
        oColumn.TitleObject.Caption = "Customer Code"
        oColumn = oMatrix.Columns.Add("2", SAPbouiCOM.BoFormItemTypes.it_EDIT)
        oColumn.DataBind.Bind("oMatrixDT", "DocEntry")
        oColumn.TitleObject.Caption = "Quote Key"
        oColumn = oMatrix.Columns.Add("3", SAPbouiCOM.BoFormItemTypes.it_EDIT)
        oColumn.DataBind.Bind("oMatrixDT", "NumAtCard")
        oColumn.TitleObject.Caption = "Cust Ref Number"
        oColumn = oMatrix.Columns.Add("4", SAPbouiCOM.BoFormItemTypes.it_EDIT)
        oColumn.DataBind.Bind("oMatrixDT", "DocDate")
        oColumn.TitleObject.Caption = "Document Date"
        oColumn.DisplayDesc = False
        oMatrix.LoadFromDataSource()

Regards,

J

Former Member
0 Kudos

Hello,

Boss you are not understanding what i have told, i don't want to merge data..i want to Merge 2 cell or make the complete row as Text Type so that user can

write manually in it ..

Same as in the Matrix of Purchase Order --> Type Column --> there are 3 option (Regular,Text,Subtotal)

so After selecting the TEXT Type how a row works..

on the same way i want to implement the same type of Row.

Thanks & Regards

Sandesh

Former Member
0 Kudos

Hello,

It is not possible.

Regards

J

Former Member
0 Kudos

As Janos said, its not possible through matrix/grid object. Not all possibilities you can see in application are exposed to SDK.

If you need this functionality, you have to look for other non SAP component (some gridview) and add it to form as activeX object.

Answers (0)