Hi,
i just want to know is there a specific configuration to share our reports in share point. The first time i used the scheduler to generate my reports for our viewer users and connect to those documents with Excel web services component, but this method does not allow users to refresh our reports.(No jet plugins in this component)
i change the method, by simply upload the documents in share point, the problem that our users could have access to Excel option and change the user name ( i guess that users could access to some Date by simply change the Code ).
My question if there is a way to hide this option? if not how can i share my documents in a secure way?
Thanks;
1 comment
-
Jet Reports Historic Posts Hi,
Excel web services in SharePoint does not support any sort of add-ins so it is not possible to refresh a Jet Report within that environment.
You are afraid that viewers will change their Excel usernames to become a designer and then change the report? Jet Reports respects your database's security, so if your users only have access to certain data in the database, then they will only be able to see that data in a Jet Reports as well even if they change a report. If you do not have your database secured, then users could use other tools besides Jet Reports to access the data, so I would recommend securing your database itself as a first step here.
If you still want to ensure that viewers are unable to change reports, you should probably switch your Jet license to use domain based naming for designers. In this model, the designers on the license are named via your network domain and domain username. Thus they could not simply change their Excel username and become a designer. You should be able to request a change of license through Jet Reports or your dealer to change to this model. Does this help?
Regards,
Hughes