Email: Password:       Forgot Password 
    .netCodeSG
A Saarsha Group Online Community for dot net codes group like C#, Asp.NET, VB.NET, Sharepoint, JavaScript, JQuery, Ajax, SQL, WCF, WPF.
 
TECHNOLOGIES:
 

Crystal Report in ASP.NET With Search Functionality

Article:
Viewed:  2112 
Posted On:  14/09/2014 07:04:22 
How we can display a crystal report with search functionality in asp.net c#? 

 

In this article I am going to show how we can show crystal report with search functionality in asp.net with c#. Here I am going to display Employee report . User can see any employee report by typing his/her name.

Now we will learn this step by step:

Below is my SQL server table, for which I will show crystal report.

1.png

Image 1.

Open Visual Studio -> File -> New Web Site.

2.png

Image 2.

Right Click on Solution Explorer -> Add New Item -> Select Data Set

3.png

Image 3.

Now Right click -> Add -> Data Table

4.png

Image 4.

Now Right Click on Header -> Add ->Column

Make sure column name and their Data type should be same as in your data table. You can change data type by selecting your added column ->Right click and select Data type property

5.png

Image 5.

Now Right click on solution explorer -> Add New Item -> Select Crystal Report

6.png

Image 6.

7.png

Image 7.

Select Project Data -> ADO.NET Data Sets-> Your Created Data Set -> Your Table -> Click Next

8.png

Image 8.

Now select column for report and click on finish.

9.png

Image 9.

Now on your aspx page add a text box , button and a report viewer like below:

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="EmployeeReport.aspx.cs" Inherits="EmployeeReport" %>
<%@ Register Assembly="CrystalDecisions.Web, Version=10.5.3700.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"
    Namespace="CrystalDecisions.Web" TagPrefix="CR" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>Employee Report</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <table cellpadding="10" cellspacing="10" width="70%" height="300px" align="center"
           style="border: solid 2px gray;">
            <tr>
                <td align="center" style="background-color: SkyBlue;">
                    Employee Name:#
                    <asp:TextBox ID="txtEmployeeName" runat="server"></asp:TextBox>
                    <asp:Button ID="btnShowReport" runat="server" Text="Show Report" OnClick="btnShowReport_Click" />
                </td>
            </tr>
            <tr>
                <td align="center">
                    <asp:Panel ID="pnlReport" runat="server" Height="400px">
                        <CR:CrystalReportViewer ID="CrystalReportViewer1" runat="server" AutoDataBind="true" />
                    </asp:Panel>
                </td>
            </tr>
        </table>        
    </div>
    </form>
</body>
</html>
 
Now aspx.cs code is:

using System;
using System.Collections;
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 System.Data;
using System.Data.SqlClient;
using CrystalDecisions.CrystalReports.Engine;
 
 
public partial class EmployeeReport : System.Web.UI.Page
{
    SqlConnection con;   
    SqlDataAdapter da = new SqlDataAdapter();
    DataSet ds = new DataSet();
 
    protected void Page_Load(object sender, EventArgs e)
    { 

    }

    
protected void btnShowReport_Click(object sender, EventArgs e)
    {
        con = new SqlConnection(@"Data Source=MyPC\SqlServer2k8;Integrated Security=True;Initial Catalog=Test");
        da = new SqlDataAdapter("select * from Employee where EmployeeName like '%" + txtEmployeeName.Text + "%' ", con);
        da.Fill(ds);
        ReportDocument rd = new ReportDocument();
        rd.Load(Server.MapPath("ShowEmployeeReport.rpt"));
        rd.SetDataSource(ds.Tables[0]);
        CrystalReportViewer1.ReportSource = rd;
    }
}
 

Now run the application:

Click on Show Report button to display report.

10.png

Image 10.

Enter Employee First name and click on Show Report Button to display report.

11.png

Image 11.

  Comment:
         HOME   |   Submit Article   |   Contact Us   |   About Us   |   Terms & Condition   |   Advertise With us