Generating password protected pdf. How to get unique password for every user?

Question

I've uploaded my reports on JasperServer where I'm scheduling the reports and send the pdf as attachments in emails to the users using the jobs rest api. Everything works perfectly, however we also need the pdf's to be encrypted. I've read the wiki topic and was able to encrypt the pdf.

But we want the passwords to be dynamic and be different for every user(for exmaple some combination of their phone numbers and date of births). The example described in the link specifies the password as a report property in the jrxml.

<property name="net.sf.jasperreports.export.pdf.user.password" value="123456"/>
<property name="net.sf.jasperreports.export.pdf.owner.password" value="123456"/> 

The password is specified as a string and is similar for every pdf generated from this jrxml.

I tried something like this

<property name="net.sf.jasperreports.export.pdf.user.password" value="{$F{dateOfBirth}}"/>

where $F{dateOfBirth} is the dateOfBirth of the user for which the query is being run. But instead of putting in the field value, it just considers it a string and sets the password to="{$F{dateOfBirth}}"

How do I go along with this? Is their any way for me to set different passwords for every user?

NOTE:The datasource is configured for the report on the jasperserver. On the job execution api call, Jasperserver executed the query, fills the report, exports as pdf and sends it as email to the user.

Answer 1

Add the following code in your Java code.

JasperPrint print = JasperFillManager.fillReport(jasper, parameters, beanColDataSource2); print.setProperty("net.sf.jasperreports.export.pdf.user.password", "jasper123");

Add in JRXML.

 property name="net.sf.jasperreports.export.pdf.encrypted" value="True" 

 property name="net.sf.jasperreports.export.pdf.128.bit.key" value="True"

 property name="net.sf.jasperreports.export.pdf.permissions.allowed" value="PRINTING"

Answer 2

As one comment mentioned, just use Java.

Here is an example, how I would code this (it's not perfect, but I think you will get it):

import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;

import net.sf.jasperreports.engine.JRDefaultScriptlet;
import net.sf.jasperreports.engine.JRScriptletException;
import net.sf.jasperreports.engine.fill.JRFillParameter;

public class GetBirthdayScriptlet extends JRDefaultScriptlet {

    private Connection conn;

    private Connection getConnection() throws JRScriptletException {
        if (conn == null) {
            if (getParameterValue(JRFillParameter.REPORT_CONNECTION) != null) {
                conn = (Connection) (getParameterValue(JRFillParameter.REPORT_CONNECTION));
            } else {
                throw new RuntimeException("No db-connection configured in the report!");
            }
        }
        return conn;
    }

    public String getBirthday(String email) throws JRScriptletException, SQLException {
        ResultSet result = null;
        String resultString = null;
        CallableStatement stmt = getConnection().prepareCall("select birthday from birthday_table where email = " + email);
        stmt.executeUpdate();
        result = stmt.getResultSet();
        if(result.next()){
            result.getString(1);
        }
        return resultString;
    }
}

Pack this little snippet into a jar and add it to your Studio Build Path and also upload it to your Jaspersoft Server.

In your report outline rightlick on Scriptlets -> "Create Scriptlet" The class of the scriptlet is GetBirthdayScriptlet (this is the codesnippet-class).

The expression you want to use in your report is:

$P{>>scriptlet-name<<_SCRIPTLET}.getBirthday("email@example.com")

Instead of entering the String, just use the parameter.

Also, maybe think of using the Jaspersoft Built In Parameter LoggedInUserEmailAddress

This helps if you want live-reports to be encrypted.