Well having fun with SUPPLIER Purchase Orders and it seems SambaPOS may be able to build a simple Suppliers Purchase Order System
I need help with some simple syntax on not showing lines on a Report where a field is Blank. Can some please assist as I still a little green on Reports?
Still cannot remove lines with blank Custom Field Data:EC.Orders?
Any reference to EC.Orders returns a blank report and any reference to $4 does the same?
No I think as that numbering is for the column place holders {x} but not returned variables? Anyway It will not test anything before the last COLON if I do not suffix ‘ASC’ to EC.Orders.asc
Also adding anything to :(ET=Suppliers) && EC.Orders!=’’ just returns a blank report…
But in 100 attempts least you got something out!
The field is a “widestr” on testing it thinks all records contain same data. So “=null” returns no records and !=null returns ALL records.