Hi Community,
We have recently begin to use the Jet Reports solution, but our process of installation it is a little bit different or complicated. We know that the program works fine in a Typical PC Installation, in which the user access to the whole program installed in its PC.
But recently, we have moved to our personal "cloud", is that to say, all users access to its personal desktop through a RDP conection through Terminal Server in our central Server. Let me explain. In my case, I access to my desktop using a thin client, which connects to our server to one of the replicated logical server in which resides all the personal desktop of our users. So I introduce my Windows User (which is in the active directory) and my password and I access to my Desktop, my programs, my printers and my documents.
Then, for all users that need to work with Jet Reports Express (JRE) we have installed the program in one of the replicated servers, but when I access to my desktop through the replicated server in which the JRE is installed, I do not see the menu and the ribbon of JRE; I need to add the JRE as an Excel Add-In or complement in order to use it (when we have installed the JRE as Administrator for all users). Tlll that point, we can make a workaround adding the JRE as a complement and see the JRE's menu and JRE's ribbon, but when we are going to setup the database and the company, I do not see any companies (although I have access to the production database); the program tells me that I do not have permission to the companies.
How can access to the companies in our production database?
Thanks in advance for as soon as possible answwer.
Regards,
Luis E. Montalvillo
Date
Votes
6 comments
-
Jet Reports Historic Posts Hello Luis -
Jet Express must be installed on each server in the farm and must be activated on each server for each user.
There are three methods you could use to register Jet Express on each server in the farm:
1) Have the user activate Jet Express anytime they access a system on which it is not already activated for them (obviously, this could be annoying)
2) Modify the login script for Jet Express users so that it calls the Jet Activation Utility (jet.activator.exe) when a user logs in
3) Modify the login script to somehow directly modify the registry.
The Registry key where Excel tracks its activated add-ins is HKCU\Software\Microsoft\Office\{version of Office}\Excel\Options
Under that key, there is a subkey created for each installed Add-In. The subkey is called "OPEN", "OPEN1", "OPEN2" etc. depending on how many add-ins are installed and activated.
The value of each subkey is the path to the VBA add-in (.xla or .xlam) to which the key corresponds.
If you want all users to have the same settings, once the Application Settings and Data Source Settings have been defined for one user, you could copy the files in which these settings are stored to the correct folder for each individual. The files are "Settings.xml" and "Data Sources.xml" are are saved in the "Jet Reports" folder located under the user's Application Data (%appdata%) folder.
Jet Express requires the ability to read from the Company table. If every role assigned to an individual's login lists a specific company, NAV will automatically deny read access to the Company table and you will receive the message, "You do not have permissions to read the company table in Navision…" when you try to test your data connection. It sounds like this is the error you are seeing.
To use Jet Express, a user needs at least one role with *no* company defined in order to give them read permission to the Company table. If a user does not have such a role assigned to them, then you will need to create this role. The role must have read permission for both the Table and Table Data for the Company table. You must add this role with no Company defined for any user who needs to use Jet Reports. This will not grant any additional privileges to the user.
In order to create this new role and assign it to users you must be a Super user.
-HP -
Jet Reports Historic Posts Hi,
Thanks a lot for the answer. It solves in a great level the problem that we have with the installation; so we try to implement your suggestions on a selected numbeer of users.
Just one more question. Create role or table permission against companies table to a particular user, without specifying any company, will give them access to all qualified companies in the database or only those companies for which they have role or permission assigned; is that to say, they will see ion Excel all companies or just only the companies they can access?
Again thanks a lot for the answer
Regards,
Luis E. Montalvillo. -
Jet Reports Historic Posts Hi Luis -
Great question!
The users would be able to query the Company table and see the names of all companies in the database (this is something that is required by Jet Essentials).
This does not, however, give the user any additional access.
-HP -
Jet Reports Historic Posts Hi HP,
Again, thanks a lot for your answer; it solves many doubts.
But for our compnay and our structure, that will be a little bit problematic. Let me explain.
In our database we have defined 9-10 companies. Five or six of them are used only by certain users, and we want that the rest of the users will not see that companies. Is that to say, Our company is a group of companies. All of them are managed by a centralized administration, but outside of the users of the Administration Department, nobody should see and should know that part of the companies that belongs to the group, exists (these are the five or six companies that we do not want that the users known, excpet the selected ones).
For us, it will be perfect that the user which is using Jet Reports for a company, will see only that company, and (I believe that) when he/she runs one of the sample reports that come in the ZIP file, if he/she does not have acces to a Item table (for example), the reports which retireve data from that table should does not work due to that restriction (he/she does not have acces to the item table, cause its roles does not allow it).
So, it would be perfect for us, that a user accessing a company in Navision and has access to only those parts of their roles Navision allow him/her, see in Jet Reports that company and running any of the predefined reports, Jet Reports will allow run this report if he/she do not have rights against predefined tables that the report contains.
It would be possible?
Thanks a lot again for the answer.
Regards. -
Jet Reports Historic Posts Hello Luis -
Unfortunately, I know of no way to accomplish this.
As I mentioned, Jet Express must have read access to the entire Company table so that it can confirm that the Company name specified in the Data Source Settings or in an individual function is an actual company.
-HP -
Jet Reports Historic Posts Hi,
Thanks a lot for your answer and sorry for the delay in mine. Ok. We will try to secure the access using the assignment of the role to the users, cause if a user do not have the role assigned, then they will not access to the companies table and then they will not acces to the reporting tool.
Regards.
Please sign in to leave a comment.