The reason I wanted to use the Table function is I am trying to add this to a larger report with several links. It sounds like I will have to start over using NL(Rows).
I am curious about your formula though. What is the 2 in front of No. and 4 in front of Date for?
Thanks!
Date
Votes
3 comments
-
Jet Reports Historic Posts I am trying to use Table builder to return service order numbers from the header and the last comment that was made on the order. Can NL(Last) be used inside of NL(table) to do this?
Thanks! -
Jet Reports Historic Posts While I don't know of a method you could use to accomplish this with the NL(Table) function, it would be a simple report to create using the NL(Rows) function.
Here is a rudimentary example which draws several fields from the Sales Header table and then goes to the Sales Comment Line table to get the last comment (based on date) for that document number.
-
Jet Reports Historic Posts I use field captions in my reports. In that way, I can use the name "State" (the EN-US 'caption') instead of "County" (the actual NAV field name).
Because I create reports that can be used in other language environments, I've turned on the setting to include the field numbers in my function references:
In that way, the report will work regardless of the language settings of the database it's being used with.
If I wanted, I could just use table and field numbers:
=NL("Last","44","6","2",C3,"-4","*")
It would work (and in any language) but isn't exactly readable ;-)
Please sign in to leave a comment.