Solved

Modifying the rsreportserver.config has no effect

Posted on 2009-06-29
3
395 Views
Last Modified: 2012-05-07
I'm trying to modify the  <Render> part of the config file. I need to alter some of the <Extension> but no matter what I do it has no effects on the report server.  
I did f.exs. remove all of the <Extension> elements in the <Render> part by adding them into <!-- -->, but I still am able to export to all of those formats anyway.

I even tried to restart the Reporting Services Services, with no success. I then deleted the Config file but then I wasn't able to restart the services, so I know that I'm altering the right config file.

Any ideas what I could do to get it to work?
<Render>
<!--
      <Extension Name="XML" Type="Microsoft.ReportingServices.Rendering.XmlDataRenderer.XmlDataReport,Microsoft.ReportingServices.XmlRendering" />
    <Extension Name="NULL" Type="Microsoft.ReportingServices.Rendering.NullRenderer.NullReport,Microsoft.ReportingServices.NullRendering" Visible="false" />
      <Extension Name="CSV" Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering" />
      <Extension Name="IMAGE" Type="Microsoft.ReportingServices.Rendering.ImageRenderer.ImageReport,Microsoft.ReportingServices.ImageRendering" />
      <Extension Name="PDF" Type="Microsoft.ReportingServices.Rendering.ImageRenderer.PdfReport,Microsoft.ReportingServices.ImageRendering" /> 
      <Extension Name="RGDI" Type="Microsoft.ReportingServices.Rendering.ImageRenderer.RemoteGdiReport,Microsoft.ReportingServices.ImageRendering" Visible="false" LogAllExecutionRequests="false" />
      <Extension Name="HTML4.0" Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.Html40RenderingExtension,Microsoft.ReportingServices.HtmlRendering" Visible="false" LogAllExecutionRequests="false" />
      <Extension Name="HTML3.2" Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.Html32RenderingExtension,Microsoft.ReportingServices.HtmlRendering" Visible="false" />
      <Extension Name="MHTML" Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.MHtmlRenderingExtension,Microsoft.ReportingServices.HtmlRendering" />
      <Extension Name="EXCEL" Type="Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer,Microsoft.ReportingServices.ExcelRendering" />
      <Extension Name="AWDOC" Type="Aspose.Words.ReportingServices.DocRenderer,Aspose.Words.ReportingServices" />
      <Extension Name="AWDOCX" Type="Aspose.Words.ReportingServices.DocxRenderer,Aspose.Words.ReportingServices"/> 
      <Extension Name="AWRTF" Type="Aspose.Words.ReportingServices.RtfRenderer,Aspose.Words.ReportingServices" />
      <Extension Name="AWWML" Type="Aspose.Words.ReportingServices.WordMLRenderer,Aspose.Words.ReportingServices" />
      <Extension Name="AWHTML" Type="Aspose.Words.ReportingServices.HtmlRenderer,Aspose.Words.ReportingServices" />
      <Extension Name="AWTXT" Type="Aspose.Words.ReportingServices.TxtRenderer,Aspose.Words.ReportingServices" />
	  <Extension Name="AWDOC" Type="Aspose.Words.ReportingServices.DocRenderer,Aspose.Words.ReportingServices"/> 
-->
		
	</Render>

Open in new window

0
Comment
Question by:gosi75
  • 2
3 Comments
 
LVL 17

Expert Comment

by:pssandhu
ID: 24736030
What are you trying to achieve exactly? Adding more options for exporting formats.
I think you should test if you delete an extension, is it affection the report server or not. Take out the comment tags, delete an extension (common one like excel), save the changes, restart all services for SQL server and then try exporting a report in report manager to excel to see if it worked or not.
P.
0
 

Author Comment

by:gosi75
ID: 24736250
I tried all this but without success. I deleted Excel extension and after restarting all of the services excel is still available for export.

What I'm trying to do is to limiting the list of extension possibilities from the report manager, by deleting some of the extensions.

Any other ideas what migth cause the changes in rsreportserver.config file not taking effect?
0
 
LVL 17

Accepted Solution

by:
pssandhu earned 500 total points
ID: 24736415
This might sound a bit silly to do but have tried rebooting the server if you are in a position to do so.
Try setting the Visible flag to false for one of the extensions and reboot the server.
P.
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
PERFORMANCE OF SQL QUERY 13 73
How to simplify my SQL statement? 14 54
Restrict result set 1 39
MS SQL Server - Looking to filter rows based on column value 3 38
by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

822 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