Hi, I want to create a report that shows Jobs with their associated Task lines, and a filter on the Creation date to give me Jobs created in a period. If I start with the Job table and link the Job Task table my report only shows the first Task Line for each Job. If I start with the Job Task table and link the Job table the filter on Creation date doesn't work and I see all Task Lines for all Jobs. Any guidence would be most welcome.
Thanks
Tim
Date
Votes
1 comment
-
Jet Reports Historic Posts Hi Tim -
While my implementation of NAV does not include a "Task Line" table, you will definitely want to start with a detail table (rather than a header table) anytime you want to see multiple records returned. The maximum records returned is always limited by the primary table.
While Jet Essentials provides the ability to limit the information returned from the "primary" table (in your case, "Task Line") based on the records returned from the "secondary" table (in your case, "Job"), Express returns all non-filtered primary records. Thus, if no filter is applied directly to a field in the primary table, all records will be returned. This keeps things simpler, but does present some limitations (as you have discovered).
-HP
Please sign in to leave a comment.