Dynamics NAV option string are stored internally in SQL as Integer.
I would like to know how can I return the integer based on an option field using a Jet Essentials formula : ie : a NF on Type=Item should return 2
Obviously I would like to achieve this using the NAV Connector and not the Universal one ;-)
Date
Votes
2 comments
-
Jet Reports Historic Posts Hi Tarek,
As far as I know, there's still no way to retrieve the option number, so the only way I know to get it anyway is…
- generate a list of all option texts on a hidden sheet;
- on the report sheet itself retrieve the option like you normally would do;
- use a VLOOKUP to look the option number up in the list on the hidden sheet.
It's a hassle but it works. If someone else has a much better solution… or if Jet USA would add the feature to Jet… -
Jet Reports Historic Posts Hi @all,
that's a really interesting question ;) , especially because you can use NL-filter with the value of an option field…
This is also the way to get a list of all used options from a table-field (like "Blocked" in the customer table)
So there might be a way or workaround….but i don't know another way like Hans described ….
regards
jetsetter
Please sign in to leave a comment.