How to dynamically encrypt PDF exports in Logi Reports using a dataset field (Patient DOB)

Hi everyone,

I'm working on a requirement to generate and export medical reports to PDF using Logi Reports. The core requirement is that each generated PDF must be encrypted (password-protected), and the password needs to be dynamically set to the specific Patient's Date of Birth (DOB).

Currently, the report is populated using a Stored Procedure as its data source.

My questions are:

1. Is there a built-in way or API in Logi Reports to dynamically set the PDF export password using a field returned from my dataset (e.g., taking the Patient_DOB column from the Stored Procedure)?
2. Is it recommended to handle the PDF generation and encryption directly inside the Stored Procedure instead (e.g., using SQL CLR or external scripts), and then pass the binary data to Logi? This seems like an anti-pattern, but I'm exploring all options.
3. If anyone has implemented a similar dynamic encryption requirement in Logi Reports, what is the best practice to achieve this?

Any insights or documentation references would be highly appreciated. Thank you!