Configuring SharePoint Reporting Service for SQL Server 2012 in Integrated Mode
Hi All, Does anyone know ***where*** to configure the "OutputFormat DeviceInfo" as described on http://msdn.microsoft.com/en-us/library/dd283101.aspx? We have SQL Server 2012 (Standard) and configured this in integrated mode with SharePoint Server 2010 (Standard). We have enabled SSRS as a service within central administation. http://msdn.microsoft.com/en-us/library/ms155866.aspx indicates that RSReportServer.config is the where "OutputFormat DeviceInfo" settings are configured? Where is this file located when using SSRS as a service within SharePoint? Is this configuration done within SharePoint? Or through powershell or code? Many thanks Kind Regards Gio
November 12th, 2012 8:14am

Hello, Please see the following resources: http://msdn.microsoft.com/en-us/library/ms156281.aspx (Changing device information settings) http://msdn.microsoft.com/en-us/library/ms155397.aspx http://msdn.microsoft.com/en-us/library/hh231593.aspx Hope this helps. Regards, Alberto Morillo SQLCoffee.com
Free Windows Admin Tool Kit Click here and download it now
November 12th, 2012 9:18am

Thanks for the quick response Alberto I looked at the links and one of them is interesting: Specifically: http://<Server Name>/reportserver?/SampleReports/Sales Order Detail&rs:Command=Render&rs:Format=HTML4.0&rc:Toolbar=FalseWhich specifies changing the output format to "HTML4.0" via the url... However if we were to schedule reports in SharePoint using SSRS scheduler we don't have this option. I would like to permanently set this option in the RSReportServer.config but in our current environment this option doesn't appear to be available. Would you or anyone else happen to know how to configure this option in SharePoint 2010 with SQL Server 2012 in place with SSRS running as a service? My only thoughts at the moment seem to be pointing to doing this in code? Regards Gio
November 12th, 2012 10:51am

Hi To clarify: We need to an enable image output format that is not enabled by default within SharePoint. SSRS is enabled as a service in SharePoint 2010. Regards Gio
Free Windows Admin Tool Kit Click here and download it now
November 13th, 2012 4:58am

Hi Gio, For SQL Server 2012 Reporting Services that runs in SharePoint Integrated mode, we still need to modify the RSreportserver.config file to customize the rendering extensions. Regarding the IMAGE rendering extension, it uses TIFF as the default output format. So, the IMAGE rendering extension is enabled actually. For more information about how to customize the IMAGE rendering extension and the available parameters for IMAGE Device Information, please refer to the following articles: Customize Rendering Extension Parameters in RSReportServer.ConfigImage Device Information Settings Additionally, the HTML4.0 rendering extension is not visible by default, however, we can still specify this rendering format using URL access. If you want to make the HTML4.0 format visible when exporting the report or creating a subscription, please move the Visible=false element from the HTML4.0 rendering extension attribute. Regards, James
November 15th, 2012 3:58am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics