Correspondence Files: How to suppress display of Records having no data in a field

I am working with source file that has a Lab Results table that has Fields for minus#4, minus#40  % passing data, AND also has other data fields  eg Mositure, etc.

I an trying to suppress the display of records for the minus#4, minusXYZ, et al, that have no value for that test. For example where there is no test result data element for that minus#4, etc  My correspondence is however, bringing in all the depths in the table, even thought there is no minusXYZ data. Yes, there is Moisture data etc, and that is why the source has all these "spurious" depths, and, of course, they are coming in because they indeed are in the source table.

Can I suppress these "blank" rows through correspondence file code.

If not, I can rewrite the external code to push the minus#4, minusXYX, et al,  to a separate source table having only that data, but I would like to put the "how to do it in giNT" in my toolbelt too.

Ideas??

 

Parents Reply Children
No Data