We are using Jet Reports with NAV. I had reports set up that were working fine, but then we got a new SQL server and had to have our NAV program reloaded. Since then I am having issues with certain fields not working correctly. It seems there may have been changes to some of the tables but when i look at them in Jet Designer, the fields and the table still seem to be called the same as before. Is there something that has to be done in Jet to detect any changes in tables or fields and update them in Jet?
Date
Votes
1 comment
-
Jet Reports Historic Posts Hi,
Jet doesn't cache or save it's list of tables and fields. The tables/fields you see in Jet are being retrieved live from your database every time, so what you see there is what exists in NAV. If you've changed your NAV language captions or something like that, you might need to export the NAV language module and point Jet at it in the Jet settings. Otherwise, Jet will just show you the table/field names rather than the captions. Does that help?
Regards,
Hughes
Please sign in to leave a comment.