Clever Geek Handbook

Password Protected PDF / Excel Reports Using SQL Reporting Services

I am creating reports using SQL Reporting 2005 services. I need to password protect my reports (pdf and excel) while the user exports the report to Excel or PDF.

Is there a way to protect the report.

+1


source to share


1 answer


The short answer is that you cannot do this from the provided PDF rendering extension from SSRS 2005 (either from the web interface or programmatically from the SSRS web services). However, you can create your own render extension that can provide this functionality. Here are some links to help you get started:

Introducing Microsoft SQL Server 2005 Rendering Extensions : Reporting Services



You can take the COTS library, some open source code, or your own code that can create password-protected PDFs and then port them into a custom extension for SSRS 2005. However, in my opinion, this can be a relatively difficult task. A quick Google search gave me no obvious selling extensions that could provide the functionality you're looking for.

+3


source






More articles:


All Articles