.aspx File

CrystalReport2.rpt File
Code File:

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Data.SqlClient ;
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;

public partial class CrystalReportPage : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        SqlConnection con = new SqlConnection("trusted_connection=true;database=praveen");
        SqlDataAdapter da = new SqlDataAdapter("select * from Item", con);
        DataSet ds = new DataSet();
        da.Fill(ds);
        CrystalReportSource1.ReportDocument.SetDataSource(ds);
        CrystalReportViewer1.ReportSource = CrystalReportSource1;
        CrystalReportViewer1.DataBind();

    }
}

Source File:
<CR:CrystalReportViewer ID="CrystalReportViewer1" runat="server"
            AutoDataBind="true" />
        <CR:CrystalReportSource ID="CrystalReportSource1" runat="server">
        <Report FileName ="CrystalReport2.rpt"></Report>
        </CR:CrystalReportSource>

 

CRYSTAL REPORT AFTER SELETCTING A ITEM- CODE IN DROP DWON LIST

.aspx File

CrystalReport3.rpt

Code File:

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Data.SqlClient ;
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;

public partial class CrystalReport1 : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
            BindDropDownList();
    }
    public void BindDropDownList()
    {
        SqlConnection con = new SqlConnection("trusted_connection=true;database=praveen");
        SqlDataAdapter da = new SqlDataAdapter("Select * from Item", con);
        DataSet ds = new DataSet();
        da.Fill(ds);
        DropDownList1.DataSource = ds;
        DropDownList1.DataTextField = "ItemCode";
        DropDownList1.DataBind();
    }

    protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
    {
        SqlConnection con = new SqlConnection("trusted_connection=true;database=praveen");
        SqlCommand cmd = new SqlCommand("Select * from Item where ItemCode=@ItemCode", con);
        SqlParameter pa = new SqlParameter("ItemCode", DbType.Int32);
        pa.Value = DropDownList1.SelectedItem.Text;
        cmd.Parameters.Add(pa);
        SqlDataAdapter da1 = new SqlDataAdapter();
        da1.SelectCommand = cmd;
        DataTable dt = new DataTable();
        da1.Fill(dt);
        CrystalReportSource1.ReportDocument.SetDataSource(dt);
        CrystalReportViewer1.ReportSource = CrystalReportSource1;
        CrystalReportViewer1.DataBind();
        BindDropDownList();
    }
}

Source File
<asp:DropDownList ID="DropDownList1" runat="server"
            onselectedindexchanged="DropDownList1_SelectedIndexChanged"
            AutoPostBack="True">
        </asp:DropDownList>
        <br />
        <br />
        <CR:CrystalReportViewer ID="CrystalReportViewer1" runat="server"
            AutoDataBind="true" />
        <CR:CrystalReportSource ID="CrystalReportSource1" runat="server">
        <Report FileName ="CrystalReport3.rpt"></Report>
        </CR:CrystalReportSource>