Export SSRS Report to PDF without using ReportViewer in ASP.NetAsk Questions

 Posted on 10/21/2019

Hi! I am using one report viewer and one asp button.

On button click i am passing parameters to the report and then generating it in report viewer.

Now i want that instead of showing it in report viewer it should be shown in any pdf viewer in pdf format. Also it would have a download pdf option so that user can download that pdf.

Share On: facebook gplus twitter
profile
Asked by Grayson Omans on 10/21/2019 Score: 60 points
Add Comment:

Comments

1 Answers

0 Corrected Answers
Aproved Answers
1
Profile
Answered by Helder Sepulveda on 10/21/2019 9:01:59 AM Score: 58 points

This is the solution i came up with :

public void ExportToPDF(string path, List<ReportParameter> reportParams,string fileName)
{
       Warning[] warnings;
       string[] streamIds;
       string mimeType = string.Empty;
       string encoding = string.Empty;
       string extension = string.Empty;

       // Setup the report viewer object and get the array of bytes

       var viewer = new ReportViewer();
       viewer.ProcessingMode = ProcessingMode.Remote;
       viewer.ServerReport.ReportServerUrl = new Uri("http://localhost/ReportServer");
       viewer.ServerReport.ReportPath = "/"+path;
       viewer.ServerReport.SetParameters(reportParams);
       byte[] bytes = viewer.ServerReport.Render("PDF", null, out mimeType, out encoding, out extension,
           out streamIds, out warnings);
 

       // Now that you have all the bytes representing the PDF report, buffer it and send it to the client.
       Response.Buffer = true;
       Response.Clear();
       Response.ContentType = mimeType;
       Response.AddHeader("content-disposition", "attachment; filename="+fileName+"." + extension);
       Response.BinaryWrite(bytes); // create the file
       Response.Flush(); // send it to the client to download
}

Comments

Add Comment:

Post Your Answers

Existing Members

Sign in to your account
Email Address
Password
New Member?
Sign up and complete profile
Full Name
Email Address
I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the StoodQ newsletters
Guideline to answer a question:

Useful tips to submit your answer
Please read below guidelines before you submit your answer for question.

  • Read and understand question for which you are submitting your answer.
  • Try to avoid grammatical and spell mistake while answering.
  • Do not post any irrelevant information in your answer.
  • Explain your answer with example or any reference link to help who posted question.
  • If you find irrelevant question, please report it to support. Click here to contact support.
  • You agree to the privacy policy and terms of use to submit any contents.

Note: StoodQ is online developers community which helps developer for their difficulty, lets help them with your value contribution.