Bind Crystal Report In ASP.NET Application And Export In PDF And Excel Format

I have already created Crystal Report for this example. You can read my previous article for creating Crystal Report,

Step By Step Creating Grouping In Crystal Report

Now follow the below steps for calling Crystal Report from ASP.NET code.

Step 1: Create a new ASP.NET project and add report in your project, here I have created Report folder and added 'CrystalReport2.rpt' file in it.

Step 2: Now add WebForm in your project by right click on Project, Add, then clicking Webform. Give it a name,

Step 3: Now, let's design your page, Drag and Drop 'RadioButtonList' and add 2 Items 'PDF' and 'Excel' add button, give a name 'btnSubmit' .

<div>
<asp:RadioButtonList ID="RadioButtonList1" runat="server">
<asp:ListItem Selected="True">PDF</asp:ListItem>
<asp:ListItem>Excel</asp:ListItem>
</asp:RadioButtonList>
<asp:Button ID="btnSubmit" runat="server" Text="Submit" OnClick="btnSubmit_Click" />
</div>

Step 5: For Crystal Report you need 2 packages from NuGet Package manager: CrystalDecisions.Shared and CrystalDecisions.CrystalReports.Engine,

Step 6: After that we have to add assemblies in our code.

using CrystalDecisions.CrystalReports.Engine;
using CrystalDecisions.Shared;
using System.IO;
using System.Configuration;

Step 7: For Connection String I have added Keys in Web.Config file, Add the following code in your web.config in <appSettings> tab.

Here I have created 4 keys for Server name, Database name, User Id, and Password.

Step 8: On Button Click event, add the following code:

Create object for crystal report Export option class.
Create object for destination option - for set path of your pdf/excel file save.
Map your crystal report path.
Set database Connection.
Select report format (pdf/excel).

protected void btnSubmit_Click(object sender, EventArgs e)
{
//Create object for crystal report Export option class
ExportOptions exopt = default(ExportOptions);
//create object for destination option - for set path of your pdf file save
DiskFileDestinationOptions dfdopt = new DiskFileDestinationOptions();
ReportDocument RptDoc = new ReportDocument();
//Map your crystal report path
RptDoc.Load(Server.MapPath("~/Report/CrystalReport2.rpt"));
//Set database Connection
setDbInfo(RptDoc, ConfigurationManager.AppSettings["V_DSN"], ConfigurationManager.AppSettings["V_DB"], ConfigurationManager.AppSettings["V_DBUserID"], ConfigurationManager.AppSettings["V_DBPwd"]);
if (RadioButtonList1.SelectedItem.Text.ToString() == "PDF")
{
//Report pfd name
string fname = "Report1.pdf";
dfdopt.DiskFileName = Server.MapPath(fname);
exopt = RptDoc.ExportOptions;
exopt.ExportDestinationType = ExportDestinationType.DiskFile;
//for PDF select PortableDocFormat for excel select ExportFormatType.Excel
exopt.ExportFormatType = ExportFormatType.PortableDocFormat;
exopt.DestinationOptions = dfdopt;
//finally export your report document
RptDoc.Export();
//To open your PDF after save it from crystal report
string Path = Server.MapPath(fname);
FileInfo file = new FileInfo(Path);
Response.ClearContent();
Response.AddHeader("Content-Disposition", "attachment; filename=" + file.Name);
Response.AddHeader("Content-Length", file.Length.ToString());
Response.ContentType = "application/pdf";
Response.TransmitFile(file.FullName);
Response.Flush();
RptDoc.Dispose();
RptDoc.Close();
RptDoc = null;
////End
}
else
{
// Excel Code goes here...
string fname = "Report1.xls";
dfdopt.DiskFileName = Server.MapPath(fname);
exopt = RptDoc.ExportOptions;
exopt.ExportDestinationType = ExportDestinationType.DiskFile;
exopt.ExportFormatType = ExportFormatType.Excel;
exopt.DestinationOptions = dfdopt;
RptDoc.Export();
string Path = Server.MapPath(fname);
FileInfo file = new FileInfo(Path);
Response.ClearContent();
Response.AddHeader("Content-Disposition", "attachment; filename=" + file.Name);
Response.AddHeader("Content-Length", file.Length.ToString());
Response.ContentType = "application/excel";
Response.TransmitFile(file.FullName);
Response.Flush();
RptDoc.Dispose();
RptDoc.Close();
RptDoc = null;
}
}

Step 9 : Here I have created common function for connecting database, and tables. Copy and paste the following code in your .cs file.

/// <summary>
/// setDbInfo - for connecting database table
/// </summary>
/// <param name="rptDoc">Crystal Report </param>
/// <param name="ServerName">Database Server name </param>
/// <param name="DatabaseName">Database name </param>
/// <param name="UserName">DB Username </param>
/// <param name="Password">DB Password </param>
protected void setDbInfo(ReportDocument rptDoc, string Server, string dbName, string UserId, string Pwd)
{
TableLogOnInfo logoninfo = new TableLogOnInfo();
// connect multiple tabel
foreach (CrystalDecisions.CrystalReports.Engine.Table tbl in rptDoc.Database.Tables)
{
logoninfo = tbl.LogOnInfo;
logoninfo.ReportName = rptDoc.Name;
logoninfo.ConnectionInfo.ServerName = Server;
logoninfo.ConnectionInfo.DatabaseName = dbName;
logoninfo.ConnectionInfo.UserID = UserId;
logoninfo.ConnectionInfo.Password = Pwd;
logoninfo.TableName = tbl.Name;
tbl.ApplyLogOnInfo(logoninfo);
tbl.Location = tbl.Name;
}
}

Step 10 : Now run your application, select PDF and click 'Submit'. It will generate PDF report and if you want Excel Report then select Excel and click on 'Submit' Button.

Here, we have't used CrystalReportViewer for Load and Display Report, Instead we have directly loaded PDF or excel report.

Hope you liked the article.

20 Comments

Join the conversation! Your thoughts help the community grow.

Guest User6y ago
Ankur i love this article, i want to create something like this but using MVC not web form. Do you know how?
Hardik Masalawala6y ago
Please upload solution with Package files and also DB scripts
Pradeep Sahoo10y ago
Nice article...Thanks for sharing...
Saktiprasad Swain10y ago
Nice article.
Sonu Chaudhary10y ago
good one
Ankur Mistry10y ago
thank you all
Santhakumar Munuswamy10y ago
Thanks for nice share
Muhammad Aqib Shehzad10y ago
nice
Sabyasachi Mishra10y ago
Good one
- Ankur Mistry10y ago
  thank you
Humayun Kabir Mamun10y ago
Nice...
- Ankur Mistry10y ago
  thank you.
Kumaresh Rajalingam10y ago
Nice one
- Ankur Mistry10y ago
  Thank you Kumaresh Rajalingam
Karthikeyan K10y ago
Good one sir
- Ankur Mistry10y ago
  Thank you Karthikeyan K
Praveen Kumar10y ago
It's awesome Ankur
- Ankur Mistry10y ago
  Thank you P K Yadav
Ankur Mistry10y ago
Thank you Arul R
Arul R10y ago
Nice share