I have made a report on outstanding leave-info per resource per department.
The objective is informing managers periodically about this issue.
As you can imagine, the department no. is to be filled in as an option.
All managers are JetViewers, so they can refresh the report, but also run it for a different department. Is there a way to prevent this?
I thought about changing the report so each department would have its own sheet, and then copy the data, but it would be so much nicer if I could run the report and send it by email to each manager without any worries.
Is it possible to protect the options sheet?
Hope someone can help me.
Willem@Marin
Date
Votes
4 comments
-
Jet Reports Historic Posts Yes, the option sheet can be hidden, and if it is hidden, they cannot edit that option.
Use "Auto+Hide+Lock+Hidesheet" to cell A1 on your options tab.
This will of course lock them from that entire page so you will need to have that Department Filter already typed on that page.
Do they still need to change some of the options? or are you trying to lock them out of all options?
If you need something other that above, let me know. There are some other options available.
Thanks,
Scott
Hammond, Indiana -
Jet Reports Historic Posts Scott,
Thanks for your answer. Think that this will do fine (for now).
It is a push-report, produced by our HR-department so there should be no need to refresh the report.
I would like to know more about the other options you mentioned; can you send me info on that?
Reading your answer I realized it came across in the Jet-training……. :oops:
Regards and thanks again
Willem -
Jet Reports Historic Posts The other option I was thinking of is…..
If you have someone that still needs to change some of the filters, but not all of them, you can put in the function that still hides the Option tab, but when each user hits "Report" to update the jetreport, it will ask them for the Options you want them to change, and it won't show them the options you want hidden.
Take a look at the attached Example. You need to put "Option" in column A, and in the same rows as a filter you want them to change. See cell A6 and A8. Then in Row 1, you need to put "Title" in the column as your filter heading, and then put "Value" in the column with your filter. In my example, those are cells C1 and D1.
By doing this, when a report is run, Jet Report will pop up a window asking for you to provide the value for those two filters. If you already have filters in there, Jet will show you what is in there. If you don't want to change them, you can just hit run report and it will continue, but you also have the ability to change the filters at that point. If you'll notice that I don't have "Option" in cell A7. This means that is not an option that the user will see when they run the report.
All that to say, the filter in A1 still has the "Hidesheet" option which will hide all filters for the viewer, and when the hit "Report" to updat the jet, they'll only be shown the options you program to come up. By doing this, you can have many options or filter, and you can specify whichever ones you want the report viewer to be able to see and change.
Let me know if you have any questions.
Thanks,
Scott -
Jet Reports Historic Posts Scott,
Thanks again for your time and effort.
I am aware of this option and use it in fact quite frequently. However it is not what i'm looking for…..
It might just be that i will have to get JetReports 2010 installed, and publish the report as PDF to the managers. Then I will really be sure they won't be able to run the report for any department than their own.
Again: thanks a lot.
Regards,
Willem\
Please sign in to leave a comment.