Re:Picture in Matrix column

[Former Member]

Hi,

I have Created a Matrix.I want to set a button like picture in one of the column in the matrix.How to achieve this.

Thanx in advance

Mohana

[Former Member · Accepted solution]

The matrix column must be it_picture type. Then you must catch event of click to cell in proper column and do some action.

[Former Member · Accepted solution]

Hi ,

I want to add some picture to that column row.How should i set a picture to that column.

Regards

Mohana

[Former Member · Accepted solution]

Normaly as other column type.

If you have this coilumn bounded to datasource, the picture cell must conatain picture name. If you have it bounded to user datasource from SAP table, its same (in one case its givin path from addon directory, in other you must set there whole path to image (c:\xxxxx\xxx.jpg).

[Former Member · Accepted solution]

Hi Peter,

Please give some example to achieve this.Thanx in advance....:-)

Regards

Mohana

[Former Member · Accepted solution]

oDBDataSource = oForm.DataSources.DBDataSources.Add("@X")

odbtable = oForm.DataSources.DataTables.Item("@X")

odbtable.ExecuteQuery(sqlquery)

column = cols.Item("colPic")

column.DataBind.Bind("@X", "U_PICT")

oMatrix.LoadFromDataSource()

[Former Member · Accepted solution]

Try by adding the col as a picture box type and then when u bind it to the datatable where in for this particular col save the path of the image....

Just check if this helps..

Vasu Natari.

[Former Member · Accepted solution]

Hi Petr,

I have used the following code for loading the image in the matrix column.my problem is, no image is loading on the column.How should i achieve this

Dim odbtable As SAPbouiCOM.DataTable

Dim sql As String

odbtable = oForm.DataSources.DataTables.Add("VEP")

sql = "SELECT u_path from [@skil_attach]"

odbtable.ExecuteQuery(sql)

oInspecCol = oColumns.Item("Inspec")

oInspecCol.Editable = False

oInspecCol.DataBind.Bind("VEP","U_Path")

I have created the table as skil_attach and i added a field as path with alphanumeric - 254

Thanx in advance

Mohana

[Former Member · Accepted solution]

Check, if the image exists in specified path - when is the image somewhere else, nothing will be shown.

For be sure copy the image to addon directory and attachment directory as well.

[Former Member]

Try adding the col with type it_PICTURE.

Vasu Natari.