Protect and encypt Jet reports

Monday, October 8, 2018 - By Jon Gardner

Protecting personal and confidential data in your Jet Reports

There are many reports that require you to protect and encrypt Jet Reports and data. These may contain detailed personal and financial information, sales commissions and perhaps percentage salary based bonus calculations.

General Data Protection Regulation

In the distant past those four words above were on the tips of our tongues back in May 2018 but now they seem almost forgotten.

Beyond the requirements of GDPR, there is justifiable need for good basic report security. So ask yourselves this, do you really want your month end P&L sent over the internet to the FD in their yacht in Monaco for potentially all to see?

There is no doubt that using Jet Reports can generate some very confidential and probably commercially sensitive information very quickly and  easily.

Encrypting a document

Generally speaking it is relatively easy to protect & encrypt Jet reports.

The best way is to open a workbook is to ask for a password. Whoever tries to open the workbook must enter the password.  

To add a password and encrypt the document follow the instruction below –

> Choose File
> Info
> Protect Workbook
> Encrypt with Password 
> Type a password and click OK  > Type the password again and click OK 
> Save the workbook

These steps need to be performed only once. The protected workbook dialogue box goes yellow and you are not required to specify the password again in subsequent resaves of the report.

Decrypting a document

When opening the file with a saved password the following dialogue window appears –

At this point, No password; No file!

In order to remove the password from the workbook it is necessary to repeat the actions above. This time delete the existing password symbols from the Encrypt Dialogue box, click OK, then save the workbook.

 If you have any questions or queries regarding how to protect & encrypt Jet reports please use the comments Box below or Contact us via our Contact Page