Hi,
We are just learning how to create reports from NAV using Jet Express. We've worked out how to create a basic report. However we are struggling to work out how to then add additional fields from NAV to these reports without having to create a whole new report - could someone please help?
Date
Votes
1 comment
-
Jet Reports Historic Posts Hello SSKINNER,
Adding fields to an existing report can be tricky depending on what table(s) the fields are coming from.
With a basic report that only queries one table you can simply add the Field Name and the Field Header to the Fields: and Headers:
You then need to expand the range listed in the NL(Table) function to include those new entries.
Below is an example from NAV001 - Top Customer Overview.xlsx
O11: Customer Phone No.
O12: Phone No.
=NL("Table","Customer",$E$12:$N$12,"Headers=",$E$11:$N$11,"TableName=","Customer","Filters=",$C$7:$D$8,…..
changed to
=NL("Table","Customer",$E$12:$O$12,"Headers=",$E$11:$O$11,"TableName=","Customer","Filters=",$C$7:$D$8,…..
If you are adding a field from a linked table then you will need to use the NL(LinkField) syntax.
O11: Search E-Mail
O12: =NL("LinkField","Salesperson/Purchaser","Search E-Mail")
The same thing applies in terms of expanding the ranges in the NL(Table) function.
Best regards,
MWilson
Please sign in to leave a comment.