Filtering Matrix Grid with CheckBox

[Former Member]

Hi,

I added filtering in my Matrix; it is working fine.

But I have checkBox in my Matrix, I cannot check my checkBox...hmmm?

I can see the checkbox, everthing is fine; but I cannot check all with my button or check only one of the checkboxes!

Any suggestion?

Rune

Edited by: Rune Brattas on Aug 27, 2008 9:51 AM

Edited by: Paul Finneran on Sep 4, 2008 12:17 PM

[Former Member · Accepted solution]

hi..

ur using userdefined form or system form.

if userdefined form means...

go to screen painter select ur column(check box)

type it_COMBO_BOX.

regards.

billa 2007

[Former Member · Accepted solution]

Hi OmPrakash,

The problem is still there...

Thank you,

Rune

[Former Member · Accepted solution]

Any one who can help me out here... ???

Thank you,

Rune

[Former Member · Accepted solution]

Hello Rune,

SAP Business One Product Support has replied to you today. If the solution is ok, can you please post it on here for everyone's benefit?

Regards,

Paul Finneran

SAP Business One Forums Team

[Former Member · Accepted solution]

The solution is negative; any positive solution from some one out there...

Thank you for waiting.

We've investigated this issue and found that it's a system behaviour.

As we can see that by setting the item's enabled property to false you

are disabling the matrix. This means that you cannot access/change any

data on that form.

By checking the system matrix, we will see that Filtering is also only

available when the matrix is disabled. Such as the report "Activities

Overview" under Reports/ Business Partners. DI API will do the same as

B1 application does. This is the system behaviour.

Thank you for your understanding and Best Regards,

Support Consultant

SAP Business One

[Former Member · Accepted solution]

Hi Paul Finneran,

Who are part of the SAP Business One Forums Team?

How do you get selected?

Thank you,

Rune

[Former Member · Accepted solution]

Hi Rune,

We have dedicated support consultants working on the forums. These are the same people working on the messages coming in to SAP. As you can understand with the volume of threads on the forum it is not possible for us to answer all questions.

You can find more information on the main Channel Partner Portal Support Page.

https://service.sap.com/~form/sapnet?_SHORTKEY=01100035870000707558&_SCENARIO=01100035870000000183&_...;

Also I have written some blog about the new processes whereby consulting questions will be referred to the forums as there are many benefit to working with a much bigger community.

It is currently limited to SAP internal, but if an external party will play a big role on the forums we would consider to change to a Forum mentor.

Regards,

Paul

[Former Member · Accepted solution]

Hi Paul,

Thank you very much for you support and feedback.

I assume we cannot have filter with checkbox and I close the ticket.

Thank you ALL!

Rune

[Former Member · Accepted solution]

Hi Rune,

It is unfortunate that this appears to be system behaviour. However you can now start to look for alternative ways to code your addon.

Regards,

Paul Finneran

[Former Member]

Hi Rune,

If your problem is not solved pls let me know.

i will give you appropriate solution.

Thanks

OmPrakash

[Former Member]

Hi Rune,

This the code you need to write to check all rows in loading form or ona button click.Before that you need to bing the check box column this way

oUDs = objForm.DataSources.UserDataSources.Add("UDS2", SAPbouiCOM.BoDataType.dt_LONG_TEXT, 20)

oColumn = objMatrix.Columns.Item("V_3")

oColumn.DataBind.SetBound(True, "", "UDS2")

For i As Integer = 1 To objMatrix.VisualRowCount

Dim oCheckBox As SAPbouiCOM.CheckBox

oCheckBox = objMatrix.Columns.Item("V_3").Cells.Item(i).Specific

oCheckBox.Checked = True

Next

HTH,

OmPrakash

[Former Member]

Hi OmPrakash,

Do I put the code in my bind method?

See below, the code is mixed with C# and VB...

public void Folder1P1BindDataToForm()
{
try
{
( ( SAPbouiCOM.Matrix ) ( oFormP1.Items.Item("Matrix1P1").Specific ) ).Columns.Item("cl1ChkBox1").DataBind.Bind("OPDNP1", "U_CheckBox01");	//0

.....

For i As Integer = 1 To objMatrix.VisualRowCount
Dim oCheckBox As SAPbouiCOM.CheckBox
oCheckBox = objMatrix.Columns.Item("U_CheckBox01").Cells.Item(i).Specific
oCheckBox.Checked = True
Next

[Former Member]

Hello Rune,

In order for us to examine the issue further can you please post the code sample here. Also can you please let us know how you are creating the form, using the screen painter or manually?

Regards,

Paul Finneran

SAP Business One Forums Team

[Former Member]

Hi Paul,

This Add-On is my first add-on and it's build manually.

I add a ruff training program. I am now on XML. , I have no XML Form with check box and cannot test your question...

Ok, here is the code:

I have 4 folders; 2 with check box and 2 without check box.

It is only the 2 folders with check box that are not working; I have no access to check my check box (the filering is working)

oFormP1.PaneLevel = 1;	// we will use the Item Event to Control the behavior of this form
						
oItem = oFormP1.Items.Add("Matrix1P1", SAPbouiCOM.BoFormItemTypes.it_MATRIX);

oItem.Left = 20;
oItem.Top = 60;
oItem.Width = 700;
oItem.Height = 380;	

oItem.FromPane = 1;
oItem.ToPane = 1;

//oItem.Enabled = false;      // Enable Matrix Filtering

oMatrix = ( ( SAPbouiCOM.Matrix ) ( oItem.Specific ) );
oColumns = oMatrix.Columns;

Edited by: Rune Brattas on Aug 28, 2008 9:58 AM

Edited by: Rune Brattas on Aug 28, 2008 10:00 AM

[Nussi]

Hi Rune,

sounds strange, maybe you found a bug.

try once the following workaround:

1. create a switch that you set to true when the matrix is in filter mode.

now you know if the filter is active and than try to catch the itemevent

when the checkbox is clicked and change the checkbox value by code

2. maybe also post a ticket to SAP

i can't promise that 1. is the best solution, maybe someelse knows it better ?

lg David