Wednesday, September 26, 2012

Using Parameter in Crystal Report

// .aspx Code
--------------------------------------------------------------------

  Enter Empid ::
  <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
<asp:Button ID="Button1"
        runat="server" Text="Show Result" onclick="Button1_Click" />
    <CR:CrystalReportViewer ID="CrystalReportViewer1" runat="server"
      EnableDatabaseLogonPrompt="False" EnableParameterPrompt="False" />

1. Add a CrystalReport File
            Solution Explorer -> Add new Item -> CrystalReport.rpt

2. Add Paramater in .rpt file



                  Add Paramater on .rpt Page


--------------------------------------------------------------------------------------------------------

//  Now Write code on .cs File on Button Click Event
---------------------------------------------------------------------------------------------------------

1.  First add Namespace

   using CrystalDecisions.CrystalReports.Engine;
   using CrystalDecisions.Shared;

2. Write code on Button_Click Event


 protected void Button1_Click(object sender, EventArgs e)
    {
        ReportDocument rd = new ReportDocument();
        rd.Load(Server.MapPath("CrystalReport.rpt"));
        rd.SetDatabaseLogon("", "");
        rd.SetParameterValue("ID", TextBox1.Text);
        CrystalReportViewer1.ReportSource = rd;
        CrystalReportViewer1.ParameterFieldInfo.Add(rd.ParameterFields[0]);
     
    }
//----------------------------------------------------------------------------

Enjoy Crystal Report

No comments:

Post a Comment