Dear Community,
I need your help :-) I am all new to Jet Report, and have been setting up the interface so it fetches data. However, when I try to set an date filter (in the GL window) I get the error that the filter is invalid. Here is a little background info on my setup:
Client:
Excel 2013 (32-bit) Danish
Regional Settings on Windows; danish (dd-MM-yyyy)
Server:
NAV2013 (English, United States) running on a English Windows Server 2008R2
Regional Settings on Windows Server; Swedish (yyyy-MM-dd)
MS SQL 2008R2 (collation: Finnish_Swedish)
I have tried every possible way (I could think of) to alter the date in the "GL Windows", however, no luck. Can anybody help? I would prefer NOT changing the regional settings on windows.
Hope you can help, BR
Frederik
Date
Votes
2 comments
-
Jet Reports Historic Posts I see that MWilson is helping you with your identical post on the Jet Express community site.
MWilson is fantastic! You're in good hands. -
Jet Reports Historic Posts I see that you were able to resolve the issue!
I thought I would share your results should anyone have a similar experience.
—
We have figured it out. You have to change the language ID of the NAV user to 1033 in the page User Personalization. On top of that, you have to change the Service Language to en-US in the NAV Administration Panel. Better to create a second web service instance so you do not have to touch existing ones.
—
Note: When using Web Services with Jet Essentials, it is a best practice to have a separate instance of NAV (specifically for Jet Essentials) with only the Jet Codeunit published.
Please sign in to leave a comment.