Our NAV database contains items and each item has a customer item no.
I want to create a JetReport where the user enters one or more customer item numbers in a column, hits "Refresh" and our own item number is generated into the next column.
I can't get it to work. What happens is that all user data is removed when the user clicks "Refresh" so the report comes out empty.
Any ideas how to do this?
Date
Votes
1 comment
-
Jet Reports Historic Posts Hi,
You need to have the place where your user enters the customer item numbers be on an options sheet that does not contain Jet formulas. With the exception of NL(Lookup) which is used for Report Options, any Jet formula on the sheet will cause Jet to treat that sheet as a report sheet and user-entered data will be destroyed when the report is refreshed. Does that help?
Regards,
Hughes
Please sign in to leave a comment.