Dynamic Password Protected report output (Part 2)

This post is in continuation of Password protected report output (Part 1) post where we discussed about generating the static password protected output. In this post we will go through steps to have dynamic password protected report output. This is a common requirement when a company send offer letter, payslips, appraisal letter etc in HCM. We might have also similar requirement when we send some bills to users.

Let's go through the required steps to enable the password protected report output.

1) Create a SQL Data Model which should have one column password like below query have NID

:

 

Note: We can have combination of one or more than one column as password.

2) Create a report for which we have to create a RTF template.

While creating the RTF template we need to setup word properties to enable the password for PDF.

Please follow the navigation: File > Info > Advance Properties > Custom

3) Add the below two properties:

Name	Value
xdo-pdf-security	true
xdo-pdf-open-password	{/DATA_DS/G_1/NID}

4) Upload the RTF template 

Now we will run the report for one employee and check the report output:



4) Enter the NID of employee the Document will open as :



Thanks for your time. I hope this will be helpful.