C#

dt.Load(dtr);
               FactCons c2 = new FactCons();//this is my crystal.rpt: means crystalreport
               c2.SetDataSource(dt);
               crystalReportViewer1.ReportSource = c2;
               c2.SetDatabaseLogon("sa", "123456");

OriginalGriff wrote:

I genuinely think he has no idea what he is doing

private void butt_prnt_Click(object sender, EventArgs e)
      {
          report();//your question
      }
      void report()
      {
          cnx = new SqlConnection(db.RXcon);
          try
          {
              cnx.Open();
      string cg=" SELECT * from Consultation where NumFact=" + @Convert.ToInt32(textBox4.Text);
              commd2 = new SqlCommand(cg);
              commd2.Connection = cnx;
              DataSet dts = new DataSet();
              DataTable dt = new DataTable();
              dtr = commd2.ExecuteReader();
              dt.Load(dtr);
              FactCons c2 = new FactCons();
              c2.SetDataSource(dt);
              crystalReportViewer1.ReportSource = c2;
              c2.SetDatabaseLogon("sa", "789654");
          }
          catch (Exception ex)
          {
              MessageBox.Show(ex.Message);
          }
          cnx.Close();
      }

crystalReportViewer1.ReportSource = c2;

c2.PrintToPrinter(1, true, 0, 0)

c2.SetDatabaseLogon("sa", "789654");

RobF_83 wrote:

is the line that actually loads the report into the report control.
You need to replace that with this:

c2.PrintToPrinter(1, true, 0, 0)

You should also place it AFTER

c2.SetDatabaseLogon("sa", "789654");

void report()
       {
           cnx = new SqlConnection(db.RXcon);
          try
           {
               cnx.Open();
        string cg=" SELECT * from Consultation where NumFact=" + @Convert.ToInt32(textBox4.Text);
               commd2 = new SqlCommand(cg);
               commd2.Connection = cnx;
               DataSet dts = new DataSet();
               DataTable dt = new DataTable();
               dtr = commd2.ExecuteReader();
               dt.Load(dtr);
               FactCons c2 = new FactCons();
               c2.SetDataSource(dt);
               crystalReportViewer1.ReportSource = c2;
               c2.SetDatabaseLogon("sa", "765432");
               c2.PrintToPrinter(1, true,0, 0);// i just add this and it works correctly

           }
           catch (Exception ex)
           {
              MessageBox.Show(ex.Message);
           }
           cnx.Close();
       }

result = (a + n*b) % b

double bearing4 = (-1.779406909 + 2 * Math.PI) % Math.PI;

Jassim Rahma wrote:

which is different that Excel

private double Mod(double a, double b)
    {
    return a - b * Math.Floor(a / b);
    }