in my practicle i want to print selected record by id or gr name but its not wokring report showing all records not seletcted where is mistakes kindly suggest me right code. protected void btnPrint_Click( object sender, EventArgs e) { SqlConnection con = new SqlConnection(@ "Connection string" ); con.Open(); SqlCommand cmd = new SqlCommand( "Select * from student_details Where grno Like'" + TextBox1.Text + "' or name like'" + studentname + "%'" ,con); SqlDataAdapter sda = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); sda.Fill(ds); ReportDocument crReport = new ReportDocument(); crReport.Load(Server.MapPath( "~/StudentsRecord.rpt" )); crReport.SetDataSource(ds.Tables[ "student_details" ]); CrystalReportViewer1.ReportSource = crReport; crReport.ExportToHttpResponse(ExportFormatType.PortableDocFormat,Response, false , "Student Records" ); con.Close(); }

Can you share what's not working? Have you checked in SQL with your query you are using, is it giving you a filtered result, share some screenshot of your issue. Edit: Here is an example showing working with CR https://www.c-sharpcorner.com/UploadFile/009464/how-to-use-crystal-report-in-Asp-Net-using-C-Sharp/

its not working can you explain me with demo code.

You didn't set the table name and uses with the table name, either add the table name or remove it from the crReport ... DataSet ds = new DataSet(); sda.Fill(ds, "student_details" ); ...

Answers

Crystal Report printing using button by where clause.

Bhavesh Vankar

529

in my practicle i want to print selected record by id or gr name but its not wokring report showing all records not seletcted where is mistakes kindly suggest me right code.

protected void btnPrint_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(@"Connection string");
con.Open();
SqlCommand cmd = new SqlCommand("Select * from student_details Where grno Like'" + TextBox1.Text + "' or name like'"+ studentname +"%'",con);
SqlDataAdapter sda = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
sda.Fill(ds);
ReportDocument crReport = new ReportDocument();
crReport.Load(Server.MapPath("~/StudentsRecord.rpt"));
crReport.SetDataSource(ds.Tables["student_details"]);
CrystalReportViewer1.ReportSource = crReport;
crReport.ExportToHttpResponse(ExportFormatType.PortableDocFormat,Response, false, "Student Records");
con.Close();
}