Please excuse me if this is a double-post. My internet went down when I tried to submit the question a few minutes ago.
My question regards the "Where-used line" table. No matter how simple or complex I make my report, Jet Reports never returns a value from this table. I have verified multiple times there is data there by navigating through Navision's "related information" tab to the "manufacturing –> where-used" info.
Ultimately what I am trying to achieve is a table showing a component part number (item table), and all the manufactured products it is associated with (where-used line table).
Thank you in advance for your expert advice.
Chris
Date
Votes
2 comments
-
Jet Reports Historic Posts Hi Chris,
Possibly whatever information you're looking for is in a different table. In NAV (assuming you're NOT using the new NAV RoleTailored Client), a good way to tell what table the information you're looking at comes from is to use Tools -> Zoom. This makes a window inside NAV pop up and the title of that window has the name of the table where the information in whatever form you're looking at comes from. Does this help?
Regards,
Hughes -
Jet Reports Historic Posts Hughes,
Thank you for your response. I did use the zoom feature to identify the correct table (Where-used line); this is how I verified there is data in the table.
One thing I have noticed is when I use the Related Information function to navigate to the Where-Used screen, the Where-Used screen shows an option for "calculation date", and the "page type" is listed as "worksheet", where the other tables I use show as "list", which makes me think the "where-used" information might be dependent upon a calculation and therefore not simple return a value from a table; but this is just a guess.
If anyone has any other input I would greatly appreciate it.
Thank you,
Chris
Please sign in to leave a comment.