I have been testing this feature and couldn't find a way to lock a Jet Report, so the end user can use it to re-generate it but not manipulate the data. +LOCK in cell A1 locks the sheet but the user can easilly go under Review tab in Excel and Unprotect Sheet. If I use a password to protect report and options sheets, I have to unprotect them before running the report…
Am I missing something here? Is there a way I can make my report both uneditable and in generating status? My users will be using Jet Reports (Viewer) to run the report but besides not editing the formula, I want them not to be able to manipulate the generated results.
Thanks
Date
Votes
5 comments
-
Jet Reports Historic Posts Hi
I tried to do the same with a macro who could potect the sheet but this did not work.
I had to unprotect to run the report as well !
Depending on the case :
The thing I did then is to use correctly an Option tab and put "+Values" in addition to "+Lock" in Reports sheet, "Viewers" will only see the result and not the fomula.
There you have to trust your users ;)
An alternativ thing we did also is to create a Macro which copy paste the Report in a new sheet within the Excel workbook.
What I did not yet used is the scheduler which seems to allow you to send a Wokbook with Values only.
Best regards -
Jet Reports Historic Posts Hi,
If all you need is a picture of your report you could show the users the "Scheduler" functionality. This way they could generate a .pdf, without the possibility to modify anyting.
Elena -
Jet Reports Historic Posts You see the problem is we want to create this report for our users to run, but we don't want them to be able to have the ability to manipulate the formulas and/or the generated results.
-
Jet Reports Historic Posts Even I don't understand why you are trying to do that I guess the only chance to reach that is to put the Jet Reports report in a macro which turns off the field lock before the report and turns on the lock after the update.
Something like:ActiveSheet.Unprotect Password:="xxxx" .. do the jet reports stuff .. ActiveSheet.Protect Password:="xxxx"
Related example http://kb.jetreports.com/article/AA-00546/0/ -
Jet Reports Historic Posts Old issue but unfortunately not resolved.
This time I have created a jet report, our users run that generates ~150 vendor sheets, which then splits and sends to separate recipients. The split has been automated with a tool.
The only problem left to fully automate this is protection.
The vendors enter data in specific cells and return back the excel, to our users. Data input is limited so that Vendors enter data only in the designated cells. I use "+Lock" option but any Vendor can unprotect the sheet and enter data anywhere they want.
Is there a way locked actually locks cells with password?
Please sign in to leave a comment.