Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Community,
How can I suppress the entire row when any value in a given record is null?
I want to show only those records in the straight table where a record does not have any null value in any column
[Pls. find sample attached file]
Thanks,
-Khaled.
Hi Khaled.
One method is to add a condition to all expressions to check for values that will cause at least one expression to have a null value.
In your application, I added a 'Not Fnd' indicator which is set to 'Y' if any field's length < 1. I then applied this indicator on all expressions. I also set the Suppress Zero Values indicator in the Presentation tab.
See the attached application.
Hope this helps,
John.
Hi Khaled.
One method is to add a condition to all expressions to check for values that will cause at least one expression to have a null value.
In your application, I added a 'Not Fnd' indicator which is set to 'Y' if any field's length < 1. I then applied this indicator on all expressions. I also set the Suppress Zero Values indicator in the Presentation tab.
See the attached application.
Hope this helps,
John.
Thanks John, it certainly works.
- Khaled.