I need to create a report where the user can list certain Sales Orders that he wants to see.
How do I set that up in Options. I have tried to do a from/thru column listing, but my results only
show the first Sales Order.
Date
Votes
2 comments
-
Jet Reports Historic Posts Couldn't you use S012345|So56789|54321|98765 in the options page? i haven't tried it yet, but figured i'd give a suggestion to try.
-
Jet Reports Historic Posts If you could be more specific, it would be easier to answer your question but here's some ideas:
Have a look at "Introducing Report Options with Database Lookup" in the HELP screens. It will allow the user to select the orders s/he wants to see in the report. The article will show you how create a database lookup. And, if you are using the later versions of Jet, go into C:\\program files\jet reports\reports\navision, you will find a file that is called "Jet Example NL(Lookup)" and you will find some great examples of how to use this feature.
The other idea is that if you know the orders you need to lookup and you have them in a list in Excel, you can do either of the following ideas:
The first is to use the NL(lookup) to refer to the listing if you want the user to use the Report Options feature. (That sample file mentioned above and the HELP screens will show you how to use Lookup with a range in Excel.
The other idea is to use NP(Join) to turn that list into the appropriate filter. Info on NP(Join) is also in the HELP screens. You basically use NP("join","Range of order no.'s","|") and it will create the list in the format as immortal_creations has shown.
Please sign in to leave a comment.