I'm using Excel 2007, Lataest Jet V, and NAV 2009
Is it possiblt to get an Excel data validation dropdown menu to reference a Jet produced list withina single cell?
What I'm trying to do is create a dropdown list of our customers that will be used as a filter for the entire report. I realize I could just manually update a hardcoded list of customers that the dropdown references, but I was wondering if there is a way to automate this process through Jet.
Thanks,
N
Date
Votes
2 comments
-
Jet Reports Historic Posts Do you really need it to be a drop down list using Excel's Data Validation? Why don't you just use Report Options? There is a great example of how to use Report Options in your Jet Reports folder called JET Example NL(Lookup). The file can be found in C:\Program Files\JetReports\Reports\Navision. I hope this is what you are really looking for!
-
Jet Reports Historic Posts See my sample report…
Create resource list and use a Data Validation Dropdown to show the data…
Please sign in to leave a comment.