Use Crystal Report In ASP.NET Using C#

We will first download the SAP Crystal report from the source, and install it on our system, then with the help of some simple code we will go ahead.

Initial chamber

Firstly, download the SAP Crystal report for respective IDE’s of Visual Studio,

• For Visual Studio 2010
• For Visual Studio 2013

Step 1: Open Visual Studio 2010 and create an Empty Website. Give a suitable name [crystalrpt_demo].

Step 2: In Solution Explorer you get your empty website, and then add a Web Form and SQL Server Database and Dataset. By following these steps:

For Web Form:

crystalrpt_demo(Your Empty Website) - Right Click, Add New Item, Web Form. Name it cry talrpt_demo.aspx.

For SQL Server Database:

crystalrpt_demo (Your Empty Website) - Right Click, Add New Item - SQL Server Database. Add Database inside the App_Data_folder.

For DataSet:

crystalrpt_demo (Your Empty Website) - Right Click, Add New Item, DataSet. Add DataSet inside the App_Code_folder.

Database chamber

Step 3: In Server Explorer, Click on your Database [Database.mdf] - Tables, Add New Table and form a table like this:

Table - tbl_data (Don’t Forget to make ID as IS Identity - True)



Insert some data inside your table by going to your table - tbl_data - Right Click and Show tbl_data. Add data in the table.

Store Procedure - sp_select :



Double Click on the dataset that resides under App_code_Folder. See the following image:



When you double click the dataset you get the blank area, there you have to do something like the following:
Right Click on the blank area -Add - Datatable.





Change the name of table from Datatable1 to Newtbl_data, there you have to add 3 columns for ID, Name, City as we had taken in tbl_data. So add three Columns. You will get something like the following image.



After this process you have to go the crystalrpt_demo- Right Click, Add New Item and find Crystal Report.rpt file.



Crystal Report Gallery will open like the following:



You got something like this:



When your crystal report opens up like the above image, then you can find in the left or right dock. Field Explorer opens up.



Right Click on Field Explorer - Database Expert, Create New Connection and you have to find the table that we had made in DataSet i.e - Newtbl_data.

Once you got your table - Add that table to right hand side pane using “ >>” button and Press OK. See the following image:



You will get your Newtbl_data in Field Explorer like the following:



Here you have to add these ID, Name and City from Database Fields to the Crystal Report - Section 3 Page Details. You can drag these fields to the Crystal Report Page Details.



Design chamber

Step 4: Now open your crystalrpt_demo.aspx file, where we create our design for crystal report, We will add Crystal Report Viewer here.

Go to the toolbox and find Reporting - Drag and Drop Crystal Report Viewer.

crystalrpt_demo.aspx