Hello,
I have created a formula that lists items in a filtered list of posted sales invoices but the formula is too long - 306 characters!
Is is possible to write a NL function to produce list of Sales Invoice Headers numbers as:
NL("AllUnique","Sales Invoice Header","No.","Posting Date",$D$3,"Sell-to Customer No.","@@"&"WG10831",,,,,,,,,,,,,,,0,"Faupel Home Furnishings")
into (say) cell J1 in a spreadsheet and then set a filter on Sales Invoice Line formula (say in cell D15) as:
FilterField1: "Document No."
Filter1: $J$1
This would reduce the number of characters to Excels allowable limits.
I have tried this but cannot get it to work.
Regards
Moe Sembi
Date
Votes
2 comments
-
Jet Reports Historic Posts Moe Sembi,
If you change your "Allunique" to "Filter", this will work. The NL("Filter") returns a string value that can be used as a filter in another NL function. Intended for filtering the contents of one table based on the contents of another.
According to the knownledge base on the support site
http://support.jetreports.com/index.php?_m=knowledgebase&_a=viewarticle&kbarticleid=135
you should use NL("Filter") instead of NL("Allunique"), unless you are trying to pass an array of values to an Excel function. -
Jet Reports Historic Posts FYI,
It looks like the formula limit in Excel 2003 is 255 characters, in Excel 2007 it's 1024.
Please sign in to leave a comment.