We upgraded to Jet Reports 2009 and some of our reports written in Jet Reports v7 give #Value error messages because of an incorrect field referenced. Our earlier reports use "Field" from the Navision tables but after the upgrade JR requires us to use "Field Name".
The issue is how do you tell Jet Reports to look at the table's "Field" versus the table's "Field Name"? I assume this is a setting specific to a user's setup because this problem does not occur for everyone. (We all have upgraded and use Excel 2007.)
For example, in our Item Table within Navision (CTRL+F8 on an item record), you can see the Field, Field Name and Value. Our reports and the Jet Reports Lookup on one user's computer uses the "Field" as a lookup and on another user's computer uses "Field Name" as a lookup. We can't share reports because what works on one computer does not work on another computer. This error only occurred after the Upgrade to 2009. What is interesting is that one user can reference either the "Field" or the "Field Name" and the report works fine.
Date
Votes
3 comments
-
Jet Reports Historic Posts Official comment Exporting the language modules and configuring them in JetReports should solve this problem…
See the JetReports manual how to do this. -
Jet Reports Historic Posts Thanks, I am going to try it now!
-
Jet Reports Historic Posts I exported the language module, configured Jet Reports 2009, restarted my computer and still it did not fix the issue.
Any other suggestions?
Please sign in to leave a comment.