How do you return information for an NL statement that excludes the null values through Jet Reports. Is their a way? Right now I am trying to gather information where a record is linked to a ContractNumber value and I am getting #VALUE because in the table it is linked with there are null values in the ContractNumber. I would like it so when it retrieves the information for the DB that it doesn't if insert the blank records into the report. I am using GP as well.
Thanks
Date
Votes
1 comment
-
Jet Reports Historic Posts I think you are looking for the
"@@"&prefix.
This allows you to have blank values in reference cells. (see: - blank filters - in jetreports help)
If I understand you correctly and you really want to exclude them, you should have an extra filter in your linked table("ContractNumber";"<>''")
Please sign in to leave a comment.