We help IT Professionals succeed at work.

SQL Server 2005 Reporting Services, Export report as Read Only

lyptus
lyptus asked
on
Medium Priority
710 Views
Last Modified: 2008-02-01
I built a report using SQL Server 2005 reporting services and Visual Studio 2005. Is there a way to make the exports read only. I don't want them to export it to excel, for example, and be able to edit.
Comment
Watch Question

Hi,

Not sure you can, as RS is limited on what it can get the exports to do.  If you export to PDF, unless the user has the full version of acrobat, this export would be read only.  TIFF export's would also be readonly.

Maybe you could write a custom rendering extension that does this, but it's a lot of work for the result!

Author

Commented:
simon kirk -
Where would I write the customer rendering extension? Is it in the rsreportserver.config file? I saw there were rendering exts for the different exports there. I thought if I commented the excel line out then excel would not be available. However, this did not work. I'm not too concerned about the work load. I really need to make this happen.
Do you know anything about the rsreportserver.config file? If I can't make it read only I would like to have the exports that can be modified removed.
Thanks,
Brett
Easiest way is to remove the export options that allow editing.  In the ReportServer config file add Visible="false" at the end of the extension you wish to hide.  e.g.

<Extension Name="EXCEL"Type="Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer,Microsoft.ReportingServices.ExcelRendering" Visible="false"/>

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Author

Commented:
I found out why it didn't work when I commented out the excel line in the config file. You have to restart IIS for it to take effect. So, if I can't set it to read only, I'll use this option.
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.