Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Is it possible to hide a row based upon a condition in a tablebox? Basically I want to exclude rows where a certain columns value is null.
Thanks
A table box cannot contain conditions / expressions ...
If you want something by hiding rows etc it can be better done in a chart (pivot or straight).
In the expression you could add something which makes the value empty when it doesn't need to be shown.
When all expression columns have a 'null' value the row is not displayed.
hope this helps you out.
Anita
Try the Presentation Tab in the properties of the table box. Select the field that has the Nulls to be excluded and check the box that allows you to Omit Rows with Null Values.
That works as a neat trick to control rows in table boxes. I often create a 1 / Null field in script to flag something (eg. Overdue item) and then use Table Box with Null excluded on that field.