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?
Can you give an example of the data? Is the data filter acting against the same field that's being displayed in the list?
If I filter for "A is not null", but am displaying B in my list, it will look empty.
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
But with below, I would only exlect 1 row returned
But I get all 3