Click here to Skip to main content
15,891,976 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
i am getting this error when i try to print crystal report from button click event
this is my code

C#
protected void Button2_Click(object sender, EventArgs e)
   {
       SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["con"].ToString());
       SqlDataAdapter da = null;
       DataTable dt = new DataTable();
       DataTable dt1 = new DataTable();

       con.Open();


       SqlCommand cmd = new SqlCommand("SELECT * FROM Transactions WHERE idcount = @idcount ");

       cmd.Connection = con;
       cmd.Parameters.Add("@idcount", SqlDbType.Decimal).Value = TextBox1.Text;


       da = new SqlDataAdapter(cmd);
       dt.Clear();
       da.Fill(dt);
       if (dt.Rows.Count > 0)
       {

           ReportDocument Report = new ReportDocument();
           Report.Load(Server.MapPath("~/CrystalReport.rpt"));
           Report.SetDataSource(dt);
           TableLogOnInfos crtableLogoninfos = new TableLogOnInfos();
           TableLogOnInfo crtableLogoninfo = new TableLogOnInfo();
           ConnectionInfo crConnectionInfo = new ConnectionInfo();
           Tables CrTables;
           Report.SetDatabaseLogon("sa", "123456789", @"TRAINING-ROOM-8", "newMreport");
           CrystalReportViewer1.ReportSource = Report;
           CrystalReportViewer1.DataBind();
           CrTables = Report.Database.Tables;
           foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables)
           {
               crtableLogoninfo = CrTable.LogOnInfo;
               crtableLogoninfo.ConnectionInfo = crConnectionInfo;
               CrTable.ApplyLogOnInfo(crtableLogoninfo);
           }

           Report.Refresh();
           Report.PrintToPrinter(1, true, 1, 1);    <--- ERROR
           con.Close();
       }
Posted
Comments
lailac88 21-Mar-13 22:08pm    
Here's an example how to view your Crystal report:

Dim report As New ReportDocument
report.Load("C:\somewhere\myreport.rpt")
CrystalReportViewer1.ReportSource = report
CrystalReportViewer1.Refresh()

1 solution

Here solved thread
http://scn.sap.com/thread/3299135[^]
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900