Export PDF or excel with password protection

[Osman]

Hi Syncfusion folks,

We are planning to use Reportviewer as our SSRS report renderer tool. One of the hard requirements we have from our customer is to provide a feature for them to export the reports with Password protection if they enabled this setting.

Is there any way to achieve this requirement with your current library? Feature or workaround solutions are welcome.

Thank you in advance.

[Yuvaraj Devarajan]

Hi Osman, 

Thanks for contacting Syncfusion support.  

In Syncfusion ReportViewer, we have an option to set the password for the exported PDF and Excel file in WebAPI controller. So we request you to specify the “UserPassword” for PDF and “PasswordToOpen” for excel in WebAPI controller as shown in below code example, 

        public void OnReportLoaded(ReportViewerOptions reportOption)  

        { 

            if (reportOption.ReportModel.PDFOptions == null || reportOption.ReportModel.ExcelOptions == null) 

            { 

                reportOption.ReportModel.PDFOptions = new Syncfusion.EJ.ReportWriter.PDFOptions(); 

                reportOption.ReportModel.PDFOptions.Security = new Syncfusion.Pdf.Security.PdfSecurity(); 

                reportOption.ReportModel.ExcelOptions = new Syncfusion.EJ.ReportWriter.ExcelOptions();                 

            } 

            reportOption.ReportModel.PDFOptions.Security.UserPassword = "coolcomp@123"; //specify the password to open the Exported PDF           

            reportOption.ReportModel.ExcelOptions.PasswordToOpen = "coolcomp@123"; //specify the password to open the Exported Excel           

        }   

  

We have prepared a ReportViewer sample and it can be downloaded from below location, 

Sample: http://www.syncfusion.com/downloads/support/directtrac/general/ze/ReportViewerSample-964016505.zip  

Please refer to the below UG documentation link to prepare a ReportViewer sample, 

https://help.syncfusion.com/js/reportviewer/getting-started  

You can obtain the complete ReportViewer sample in below build installed location, 

%userprofile%\AppData\Local\Syncfusion\EssentialStudio\version\JavaScript\samples\Web  

Regards, 

Yuvaraj D.

[Osman]

Thanks for the answer. I will try out this.

[Yuvaraj Devarajan]

Hi Osman, 

Thanks for your update. We will wait to hear from you.  

Regards, 

Yuvaraj D. 

[Osman]

Hi again,

The suggested solution worked perfectly. Thank you very much.

[Yuvaraj Devarajan]

Hi Osman, 

Thanks for the update. We are happy to hear that your problem is resolved. 

Regards, 

Yuvaraj D.