We are new to NAV / Jet Express as of 1/1. I am trying to run a simple report of local taxes. When I do, it works fine except that it only brings into the report the first local tax listed. Where we live, most have two taxes such as a city and school tax or a city and county and we are using the split local function. How do I get all lines of data? Or is this a limitation of Express? Thanks!!
Date
Votes
1 comment
-
Jet Reports Historic Posts Hello -
If used to draw information from multiple tables, the NL(Table) function will return - at most - the number of records contained in the primary table.
Thus, if we were to create a function that draws from both the 'Customer' table (my primary table) and the 'Cust. Ledger Entry' table (my secondary table), the results would contain - at most - the number of matching records from the Customer table.
If we reverse the tables (making the 'Cust. Ledger Entry' table out primary table) then we would be able to achieve results listing multiple records from that table.
When drawing information from a single table, the current version of the Jet Express NL(Table) function always returns "unique" values.
Let's look at an example.
Let's assume we have a NAV table with 5 records - each with three fields: "A", "B", and "C". We'll further assume that Field "A" represents our record number.
A - B - C
—————–
1 - X - Y
2 - Y - Z
3 - X - Y
4 - U - V
5 - Y - Z
If we use the function: =NL("Table",{"B","C"})
to return just Fields B and C, we will get the following:
X, Y
Y, Z
U, V
Even though we have a total of 5 records, since record 3 is a match to record 1 and record 5 is a match to record 2, we'll only get the three "unique" combinations of fields "B" and "C".
If we want to see all the records, we need to include enough fields in our function to uniquely identify each record.
In this example, we could use the function: =NL("Table",{"A","B","C"}) since the combination of all three fields will (in this example) always be unique.
I hope that helps.
-HP
Please sign in to leave a comment.