Asp.Net Export to PDF using Crystal Reports

In this post Asp.Net Export to PDF using Crystal Reports, we shall see on how to export the content of a Crystal report to a PDF file. 

Here we will use the report which we designed in the port Crystal Reports CrossTab Report in Asp.Net. To know more on the basics of how to create a Cross-tab report refer the post Crystal Reports CrossTab Report in Asp.Net.

All the procedures for designing the report, binding the data to the report will remain same as we saw in the post Crystal Reports CrossTab Report in Asp.Net. Here instead of displaying the report in the CrystalReportViewer, we will export the report as a PDF file.

Add the following lines of code before and after binding data to the CrystalReport

Before
HttpContext.Current.Response.Buffer = true;

HttpContext.Current.Response.AddHeader("Content-Disposition", "inline; filename=Report.pdf");

HttpContext.Current.Response.ContentType = "application/pdf";

MemoryStream objStream;

After
objStream = (MemoryStream)objRptCrossTab.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);

HttpContext.Current.Response.Clear();
HttpContext.Current.Response.BinaryWrite(objStream.ToArray());

The complete code is as follows

HttpContext.Current.Response.Buffer = true;

HttpContext.Current.Response.AddHeader("Content-Disposition", "inline; filename=Report.pdf");

HttpContext.Current.Response.ContentType = "application/pdf";

MemoryStream objStream;

// Add Data access code to get the data into the Dataset dsCrossTab
objRptCrossTab = new rptCrossTab();

objRptCrossTab.SetDataSource(dsCrossTab);

// Export the Report to PDF

objStream = (MemoryStream)objRptCrossTab.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);

//

HttpContext.Current.Response.Clear();

HttpContext.Current.Response.BinaryWrite(objStream.ToArray());

Save and run the page, the File Download dialog will pop-up, you can save the PDF file to the disk by selecting the required location.

That's it we have exported a Crystal Report to PDF file using Asp.Net