In this month topic, we will discuss how to add passwords to reports that are downloaded from Report mode or via report binder.
It is important to note that password protection is considered one of the data security access control layers that helps to protect sensitive information from unauthorized access.
Password protection for reports extracted to Excel via Report Mode:
You can add password protection when downloading to Excel for added security. To accomplish this, please follow the following steps.
- Open the report in Design Mode.
- Click on the Options button in the Navigation Panel:
- In the Options pop-up, click on the ‘Save As Excel’ tab.
- Toggle the Documentation Protection button ON ,and set a custom password.
Note: Note down or store offline your custom password in case other users need it.
- Click OK to save the report updates. The next time you send this report out to Excel. It will ask you to enter the password.
Password protection for reports extracted to Excel via Report Binder:
Report Binder allows you to password protect reports extracted to Excel using a password. The following steps will guide you through the process.
- Navigate to Report Binders and open the relevant report.
- Click on Options on the top left.
- Select the Security tab.
- Select Apply document protection.
- Decide on a password for pdf and/or excel.
Note: Ensure you keep a copy of the password in a secure place or create a password you can remember.
After this is set up, you may run the Report Binder process to send it out to your users as normal. The only difference is that the file is now password locked before anyone can open and view the contents.