Is there an easy way to do the above, based on evaluation of an "If" statement?

Hi Claus,

You could use the row extended properties and toggle the visibility of the row based on a certain condition:



Note that this option only hides the row (doesn't actually remove it from the table). If you'd like to remove it from the table you should work at query level (or transformation) to make sure that the row is not on the source record list.

Cheers,