I have the following =NL("Rows","Item Ledger Entry","Entry No.","Item No.","@@"&$E4,"Remaining Quantity","<>0")
E4 is never empty, although I think I've accounted for it anyway. The problem is that sometimes the Item Ledger Entry table does not have any entries for an Item, so Entry No. cannot be found. I get an empty filter error, even when I hard code E4. I cannot nest this in an IF statement because then the Rows do not expand. I can insert a column before this with a count of the number of Items in the Item Ledger Entry, but don't know how to use that information without the IF.
Any help is appreciated.
Date
Votes
2 comments
-
Jet Reports Historic Posts Official comment Hi Reid,
If you could include a copy of your report that would be helpful to see what exactly is going on but my guess is that in cell E4 you have one of your report filters.
If that is the case, I bet the report works fine if you have E4 equal to * or if you only have 1 item number listed as a filter. It is when you have multiple items that the report breaks.
If this is the case, remove the "@@"& from your Jet function because it is treating your item number filter incorrectly. The @@ accounts for a blank cell but also allows special characters such as & | .. > < and others.
As soon as you enter in two or more items ("1920-S|1930-W") the @@ tells Jet to look at that whole string as one value. Instead of looking for 1920-S OR 1930-W it is now looking for item 1920-S|1930-W and that isn't a valid item number.
If this doesn't solve the issue, could you include a copy of your report for review? -
Jet Reports Historic Posts I actually solved my problem trying to rephrase the question.Thank you
Please sign in to leave a comment.