I know in the earlier version that the company table had to have no company lock on it for Jet reports to work. I am just wondering if this limitation has been fixed in 2009?
Thank you for your help.
Date
Votes
4 comments
-
Jet Reports Historic Posts Hi acemcgee,
Are you referring to the fact that Jet Reports users need read permission to the Company table without a company specified? This is actually not required in newer versions of Nav. We use Microsoft Navision C/Front to connect to Nav and previously when we asked C/Front for the company list, we would get an error if the user did not have unrestricted permission to the Company table. As far as I can tell, in Navision 4.0 SP1 and newer (the versions supported by Jet Reports 2009), this is no longer a requirement. Even if you are using Jet Reports v7 this doesn't seem to be required in these newer versions of Navision, so something about the way C/Front gets the company list must have changed in the newer versions of Navision. Does this answer your question?
Hughes -
Jet Reports Historic Posts I am working with Jet Essentials 2011 build 11.0.11209.0 on a NAV2009 R2 SQL database and still have this problem. If I assign a specific company name to user roles in NAV it is not possible to connect to the data source. Jet produces the error "no permission to read company table". A possible workaround is to create a read-only NAV role on the company table (2000000006). This however is what I wanted to avoid in the first place as I do not want the users to see the full company list in NAV. I also tried to add a security filter on the read-only NAV role with the specific company name, but that doesn't work either.
Any other suggestions? Do some of you know if this problem is being worked on? -
Jet Reports Historic Posts I am working with Jet Essentials 2011 build 11.0.11209.0 on a NAV2009 R2 SQL database and still have this problem. If I assign a specific company name to user roles in NAV it is not possible to connect to the data source. Jet produces the error "no permission to read company table". A possible workaround is to create a read-only NAV role on the company table (2000000006). This however is what I wanted to avoid in the first place as I do not want the users to see the full company list in NAV. I also tried to add a security filter on the read-only NAV role with the specific company name, but that doesn't work either.
Any other suggestions? Do some of you know if this problem is being worked on?
Hi,
look here http://community.jetreports.com/viewtopic.php?f=7&t=2184&p=6342&hilit=company#p6342
I had the same problem, and solved it with the suggestion from the "link" -
Jet Reports Historic Posts Hi,
look here http://community.jetreports.com/viewtopic.php?f=7&t=2184&p=6342&hilit=company#p6342
I had the same problem, and solved it with the suggestion from the "link"I do not want the users to see the full company list
Please sign in to leave a comment.