Export formats in SSRS
HI All, When I am exporting my report to PDF ....All of my report is not showing up in the PDF Doc.....Is there any way to avoid that ...so that we can see the entire report..? And one more thing......If I need to export to other formats...is there a way to do that...? Right now I am seeing only two formats in my report (Excel and PDF). ....If I want my report in .CSV.....is there a way to do that. If so let me know..ASAP Waiting for your response.. Thanks, vineesh1701
October 14th, 2010 11:00am

Hi vineesh1701, Did you mean that you got blank pages in the exported report(PDF format)? If so, it may be due to unsuitable report size settings. Please see the follow article for more information: http://blogs.msdn.com/b/chrisbal/archive/2006/08/10/694892.aspx By default, in SSRS 2008, a report can be exported to the following format: EXCEL Web archive Acrobat(PDF) file TIFF XML CSV WORD These formats are configured in the rsreportserver.config. In this case, I would suggest you checking if the following configuration is existing the configuration file: <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="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"/> For more information, please see: Exporting Reports: http://msdn.microsoft.com/en-us/library/ms157153(v=SQL.100).aspx If you have any more questions, please feel free to ask. Thanks, Jin ChenJin Chen - MSFT
Free Windows Admin Tool Kit Click here and download it now
October 19th, 2010 11:32am

If you are using RDLC's then you will certainly be limited to PDF and Excel Export Formats , RDL's will certainly have all the export formats mentioned in the above post . Thanks .Rajkumar Yelugu
October 19th, 2010 12:05pm

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

Other recent topics Other recent topics