| Issue | I am designing a JET that keys on table 50030, Posted Incident. The JET needs to be able to filter for 'Position Code' per table 50031, Posted Incident Position Line. However, current table structure does not permit this. In addition to filtering for various fields in table 50030 (using an NL key and assorted NF's), the JET Viewer wishes to filter for certain fields that are in table 50031. I cannot anyway to connect the two. Is it possible to adjust the current table keys to accommodate this? |
| Solution |
You can use filter arrays in version 4.07 to accommodate this situation: (Excerpt from Jet Reports Navision User Guide.doc, Starting on Page 28.) Please see Advanced NL Section excerpt attached. |
Jet Reports Design - Filtering based on data from another table Print
Modified on: Mon, Dec 12, 2016 at 3:25 PM
Did you find it helpful? Yes No
Send feedbackSorry we couldn't be helpful. Help us improve this article with your feedback.