PowerBuilder: How to filter in the Group Definition Expression in a Datawindow.

[Former Member]

Hi, I have PowerBuilder 8.

I have a Datawindow with one group.

I need to filter the results shown in the group to avoid empty results.

For example, if the datawindow's SQL returns:

ID Name1 Quantity1 Name2 Quantity2

1 Bread 50 Wine 3

2 Water 20

3 Bread 30 Wine 3

If the group defintion uses the columns "Name2" and "Quantity2", the result are 2 rows, one with data "Wine 3" and the other "empty", so it shows a blank that I don't want.

I can't filter in the SQL because I need also the data "Water 20" to fill another field of the datawindow.

How can I do that? I want to group only when the Name2 and Quantity2 have data.

Thanks in advance,

[Former Member]

Hi, could somebody tell me if it's possible to filter the results with an expression in a datawindow "group definition"?

I have tried to add the "Name2" field with the expression (Name2 = "Wine"), but nothing different happened.

Thanks in advance.