Print current Record

Bhavesh Vankar

i have tried below code to print current record on crystal report.Report is generated when press button but report is blank printing. records not printing on crystal report what to do...?

SqlConnection con = new SqlConnection(this.con);
SqlDataAdapter sda = new SqlDataAdapter("Select * from S_TEST Where S_ID='" + txtidno.Text + "'", con);
DataSet ds = new DataSet();
sda.Fill(ds);
ReportDocument rpd = new ReportDocument();
rpd.Load(Server.MapPath("~/Report/studentpass.rpt"));
rpd.SetDataSource(ds.Tables[0]);
CrptViewer.ReportSource = rpd;
rpd.PrintToPrinter(1, false, 0, 0);

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Bhavesh Vankar5y ago
trid but still not working....
+1
Sachin Singh5y ago
test this
private void PrintForm_Load(object sender, EventArgs e)
{
    ReportDocument cry = new ReportDocument();
    try
    {
        cry.Load(@"C:\Reports\studentpass.rpt");//your full report path
        SqlConnection con = new SqlConnection(this.con);
        SqlDataAdapter sda = new SqlDataAdapter("Select * from S_TEST Where S_ID='" + txtidno.Text + "'", con);
        DataSet st = new DataSet();
        sda.Fill(st, "Student");
        cry.SetDataSource(st);
            cry.PrintToPrinter(1,false,0,0);
        }
        catch(Exception ex)
        {

        }
    }
+1