Export SSRS report directly to PDF or Excel Format(without Report Viewer)
In this post, we are explaining how SSRS report can be directly exported to PDF or Excel.
//Show PDF report accepts 3 parameters, report is the name of the report on the report server, reportParameters is the parameter required for the report to run, fileName is the name in which you want the report to be stored
public static void ShowPdfReport
(string report, Dictionary<string, object> reportParameters,string fileName)
{
try
{
Screen screen;
//Get the server and the server path from Web config
string reportUrl =ConfigurationManager.AppSettings["server"];
reportUrl += "?" +ConfigurationManager.AppSettings["serverPath"];
string reportParametersQT = String.Empty;
foreach (var entry in reportParameters)
{
reportParametersQT += "&" + entry.Key + "=" + entry.Value;
}
/*Creating a web request using the reportUrl,the report,the format in which the report is to be displayed and the report parameters.
Here rs is a built in parameter of Reporting Services and I am instructing reporting services to render(rs:Command=Render)the report in PDF format(rs:Format=PDF),to export the report in Excel all you have to do is change the format to (rs:Format=Excel)*/
WebRequest req = WebRequest.Create(reportUrl + report + "&rs:Command=Render&rs:Format=PDF" + reportParametersQT);
//Passing the credentials of the report server
req.Credentials = newNetworkCredential(ConfigurationManager.AppSettings["username"], ConfigurationManager.AppSettings["password"]);
//Creating a response object
WebResponse response = req.GetResponse();
Stream stream = response.GetResponseStream();
screen.Response.Clear();
string enCodeFileName = HttpUtility.UrlEncode(fileName, System.Text.Encoding.UTF8);
// The word attachment in Addheader is used to directly show the save dialog box in browser
screen.Response.AddHeader("content-disposition","attachment; filename=" + enCodeFileName);
screen.Response.BufferOutput = false; // to prevent buffering
screen.Response.ContentType = response.ContentType;
byte[] buffer = new byte[1024];
int bytesRead = 0;
while ((bytesRead = stream.Read(buffer, 0, buffer.Length)) > 0)
{
screen.Response.OutputStream.Write(buffer, 0, bytesRead);
}
screen.Response.End();
}
catch (Exception e)
{
}
}
