Can't export to PDF

the PDF option is not available in the dropdown list of export formats after running a report in SQL Server Reporting Services.  The only options available are XML, CSV, Excel, MHTML and Word.  

But the report server config file shows that it is enabled.

The event viewer has recent errors that read:

Report Server Windows Service (MSSQLSERVER) cannot load the PDF extension. 

There are similar errors for RGDI and IMAGE extensions as well.

Running version 10.50.1600.1 of MSSQLServer on a Windows 2008 SP2 64-bit server.

The machine has recently been rebooted recently with no effect.  Here are the pertinent contents of the rsreportserver.config file.  and it's not in any of the Excluded render types in other secions.

  <Render>
   <Extension Name="XML" Type="Microsoft.ReportingServices.Rendering.DataRenderer.XmlDataReport,Microsoft.ReportingServices.DataRendering"/>
   <Extension Name="NULL" Type="Microsoft.ReportingServices.Rendering.NullRenderer.NullReport,Microsoft.ReportingServices.NullRendering" Visible="false"/>
   <Extension Name="CSV" Type="Microsoft.ReportingServices.Rendering.DataRenderer.CsvReport,Microsoft.ReportingServices.DataRendering"/>
   <Extension Name="ATOM" Type="Microsoft.ReportingServices.Rendering.DataRenderer.AtomDataReport,Microsoft.ReportingServices.DataRendering" Visible="false"/>
   <Extension Name="PDF" Type="Microsoft.ReportingServices.Rendering.ImageRenderer.PDFRenderer,Microsoft.ReportingServices.ImageRendering"/>
   <Extension Name="RGDI" Type="Microsoft.ReportingServices.Rendering.ImageRenderer.RGDIRenderer,Microsoft.ReportingServices.ImageRendering" Visible="false"/>
   <Extension Name="HTML4.0" Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.Html40RenderingExtension,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="RPL" Type="Microsoft.ReportingServices.Rendering.RPLRendering.RPLRenderer,Microsoft.ReportingServices.RPLRendering" Visible="false" LogAllExecutionRequests="false"/>
   <Extension Name="IMAGE" Type="Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRenderer,Microsoft.ReportingServices.ImageRendering"/>
   <Extension Name="WORD" Type="Microsoft.ReportingServices.Rendering.WordRenderer.WordDocumentRenderer,Microsoft.ReportingServices.WordRendering"/>
  </Render>

Thanks,

Brian
December 16th, 2013 5:10pm

Hi Bjcos,

The issue may occur because the corresponding assembly function doesnt exist or has error when calling this function to load PDF, RDGI and Image render extension.

In this case, I suggest you viewing the ReportServer Log file which is located C:\Program Files\Microsoft SQL Server\MSRSXX.MSSQLSERVER\Reporting Services\LogFiles, you can check whether there is similar information below:

Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error.  ---> System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.ReportingServices.ImageRendering2' or one of its dependencies. The system cannot find the file specified.

If its not the case, please post the log details to the forum for further analysis.

Reference: http://support.microsoft.com/kb/2146315/en-us

Regards,
Heidi Duan

Free Windows Admin Tool Kit Click here and download it now
December 17th, 2013 4:32am

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

Other recent topics Other recent topics