Empty rows appear in List

[PaulHallett1305]

Hi, I use a data expression to create the table I use in a list.  However, empty rows appear in the data.  The query is quite a long one, but, explicitly, the filter states it can not have empty rows.

Data is fine and formatted in all the other rows, but these empty ones keep appearing.

Any idea how to get rid of them?

 

[jcarlson]

Can you give an example of the data? Is the data filter acting against the same field that's being displayed in the list?

A	B
1
	5
2

If I filter for "A is not null", but am displaying B in my list, it will look empty.

[PaulHallett1305]

Hi Josh

Basically, the filter is

Select * from table where cola = 1

or colb = 1

or colb = 3

or colc = 4

I would expect all 3 rows to return

1
1		4
	3

But with below, I would only exlect 1 row returned

1

But I get all 3