SQL Server 2005 Reporting Services, Export report as Read Only

Posted on 2006-03-30
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.
Question by:lyptus
    LVL 14

    Expert Comment


    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 Comment

    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.
    LVL 14

    Accepted Solution

    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"/>

    Author Comment

    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.

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Join & Write a Comment

    Hi, I am very much excited today since I'm going to share something very exciting Tool used for Analytical Reporting and that's nothing but MICROSTRATEGY. Actually there are lot of other tools available in the market for Reporting Such as Co…
    Hi, In my previous Article  ( discussed some basic understanding of Microstrategy that how we can get in Intro of Microstrategy (MSTR). Now it's tim…
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now