on 04-06-2010 1:01 PM
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
Hello,
This is not supported in Matrix / Grid
Regards,
J
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
User | Count |
---|---|
89 | |
8 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.