Hi all !
I want to make sure of my understanding on how Jet Report apply NAV permission security.
My company designed a report that is put on the Scheduler to be automatically generated each week. The administrator of the Scheduler has super-user permissions in NAV.
When a restricted user opens the report generated by the scheduler, he can see ALL information instead of only the one authorized by his permission set.
However, when the restricted user refresh the report by himself, then the security applies.
Does that mean that the security only applies when the report is refreshed by the user ?
If yes, how can we schedule reports to be generated but still applies security ?
Thanks !
Date
Votes
2 comments
-
Jet Reports Historic Posts Jet follows the permissions setup in NAV for retrieving the data. If the Super User is saving the report then it will show everything because that user had the permissions to pull the data. If another user attempts to get the data then it doesn't work as you noted. I would setup multiple reports for this with the information on each that the user needs to access.
-
Jet Reports Historic Posts To tack on to Jason's response.
When you Run a report through the Scheduler, at execution, Jet retrieves the data from NAV and stores it in Excel. Because the data is already stored in Excel, regardless of who opens the report, they'll see all data that was retrieved when the Super User ran the report.
As Jason suggested, the best solution is to have multiple tasks in the Jet Scheduler. One for each of your users who need to access the data. I just published a blog post on my site about how to use the Scheduler to accomplish a similar task!
http://www.onyxreporting.com/blog/jet-essentials-jet-scheduler-and-named-ranges
Please sign in to leave a comment.