C# – Generating a Reporting Services 2005 PDF report and storing it on disk

asp.netcpdfreporting-servicessql server

Is there an easy way to generate a PDF report from an RDL that's been uploaded to Report Manager and put that file somewhere on the server's disk? I already have a location on disk to put the file, I just need to know how to programmatically generate the PDF. This is for SQL Server 2005 Reporting Services. Code in either VB or C# is fine.

Best Answer

This article will show you how you can generate PDF report from reporting service, without using report viewer. Only change you have to do is to write the result byte array into a file stream instead of sending it to response stream as shown in that example. The above mentioned example is using the web services provided by SQL reporting service to generate report.