Tuesday, 19 August 2014

Crystal Report show

    // Report Source
            ds.Clear();
            string str1 = "Select * from T_ReportTotal Where ID=1";
            OleDbDataAdapter ada = new OleDbDataAdapter(str1, con);
            ada.Fill(ds, "T_ReportTotal");
            cr1.Refresh();
            cr1.SetDataSource(ds);
            progressBar1.SendToBack();
            progressBar1.Visible = false;
            crystalReportViewer1.Visible = true;
            crystalReportViewer1.ReportSource = cr1;
            cr1.SetParameterValue("From", dtpFrTotsale.Text);
            cr1.SetParameterValue("To", dtpToTotsale.Text);
            Cursor.Current = Cursors.Default;
            crystalReportViewer1.Cursor = Cursors.Default;
            con.Close();

No comments:

Post a Comment