Intellicus allows you to password protect files (MS EXCEL (xlsx), MS WORD (docx), MS POWERPOINT (pptx), PDF) while exporting or scheduling to ensure secure access to reports. In the current version the feature is available for Adhoc and Studio report types.
Report designers are required to set password in order to allow use of this feature.
Follow below steps to set password for Adhoc reports
Go to Navigate > Administration > Configure > Config Files
Open the irl template file from Adhoc Template File in which you want to set the password.
Use the below script to set the password:
OnReportStart()
{
rpt.Fields(“SYS_EXPORT_PSD”).value= “(here, provide a password string/ parameter to pass as a password string);”
}
For Studio reports – Navigate > Design > Studio Reports > Script Editor
Select OnReportStart function from the drop down.
Use the below script:
{
rpt.Fields(“SYS_EXPORT_PSD”).value= (here, provide a password string/ parameter to pass as a password string);
}