Create Crystal Reports Report in ASP.Net

Rahul Kumar Saxena

6y525.9k31100Article

31 Comments

Join the conversation! Your thoughts help the community grow.

salman Ahmed5y ago
How to set credential login?
Ritwik Sahasrabuddhe8y ago
It shows blank output in VS2015 using these Steps
Pankaj Khairnar8y ago
It shows blank output
Jyothi Augustine8y ago
Unable to create crystal report using above instruction for vs 2015
amjad s r8y ago
Thanks..... Nice article.......
Sandeep Singh10y ago
How to set header height and width of crystal report
Sandeep Kumar10y ago
unable to create crystal report using above instruction for vs 2012
Pradeep Sahoo10y ago
Nice article...Thanks for sharing
Uzair Ansari10y ago
i am working on visual studio 2015 is there any version issue
Uzair Ansari10y ago
unable to create crystal report on using above instruction,
Rahul Kumar Saxena10y ago
Thanks 2 All
Rahul Kumar Saxena10y ago
I will write soon on your requirement Veera Muthu & hothorasman panjaitan
Rahul Kumar Saxena10y ago
Thanks Sonu Chaudhary
Sonu Chaudhary10y ago
good one article
hothorasman panjaitan10y ago
how to display image from path, in crystal report asp.net
veera muthu10y ago
how to create crystal report without using sqlconnection ? then i need static image inside the crystal report...Help me Sir??????
Rahul Kumar Saxena11y ago
Thanks Aappasaheb Tawale
Rahul Kumar Saxena11y ago
Are you talking any object ...chaitanya kumar
chaitanya kumar11y ago
I am getting bobj is undefined.How to resolve this issue
Aappasaheb Tawale11y ago
Really helpful me. Thank you
mustafa essoufi11y ago
hi, I followed the steps and whene i execute no data display (i'm working with vs 2012)
Rahul Kumar Saxena11y ago
Thanks Santhakumar Munuswamy...
Santhakumar Munuswamy11y ago
Good work
Rahul Kumar Saxena11y ago
Thanks 2 All..
Rahul Kumar Saxena11y ago
Thanks Rakesh..
Rakesh11y ago
it's nice demo.
Rakesh11y ago
Thank you.
Saineshwar Bageri11y ago
nice start
- Rahul Kumar Saxena11y ago
  Thanks a lot Saineshwar Bageri
Praveen Kumar11y ago
good...
- Rahul Kumar Saxena11y ago
  Thanks s lot Praveen Kumar

The following is my Employee Table, of which the data I will show as a report in ASP.NET using Crystal Reports.

Image 1.

Now open Visual Studio then select File -> New -> Web Site.

Image 2.

Then right-click on the Solution Explorer then select Add New Item then select Crystal Reports then click Add.

Image 3.

Image 4.

Here expand something then select Create New Connection then select OLE DB (ADO) then a pop-up window will open. Select Microsoft OLE DB Provider for SQL Server then click Next.

Image 5.

Now enter your SQL Server details.

Image 6.

Image 7.

Now select your database then select your table and Move.

Image 8.

Now select the columns to be shown in the reports. Then click Finish.

Image 9.

Now you can see your report is ready. All the columns are already in the Details sections. You can remove any column or you can add a new column by drag and drop from the fields explorer to the report.

Image 10.

Now to add a Report Viewer for showing this Crystal Reports report. In the Default.aspx page drag and drop a CrystalReportViewer from the toolbox like the following.

Image 11.

Now for the Page_Load event write the following code:

using System;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using CrystalDecisions.CrystalReports.Engine;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
ReportDocument cryRpt = new ReportDocument();
cryRpt.Load(Server.MapPath("EmployeeCrystalReport.rpt"));
CrystalReportViewer1.ReportSource = cryRpt;
}
}

Now run your application:

Image 12.