I am generating a reports using SQL Reporting services 2005. I need to protect the protect the reports(pdf and excel) with the password while the user is exporting the report to to excel or pdf.Is there any way to protect the report.Thanks in advance... Bala

Hi - Reporting services does not currently have the feature to password protect (or add rights-management) to documents that are generated. You might look at Office IRM capabilities:http://office.microsoft.com/en-us/help/HA101029181033.aspx. You might be able to apply protection to the files you generate if you post-process them after rendering from the report server. We are considering the addition of native support for Office IRM in a later release.Hope that helps.-JonHPMicrosoft SQL Server Reporting Services

Hi JonHP, Could you pleas tell me what do you mean by post-process and how can i do that Thanks -Aravind