Crystal reports with SQL Query in c sharp app

See more:

C#

Hi All, need help on the developed c sharp windows application for reports. I have added the crystal report and crystal report viewer, i am getting blank datas generated in reports, below is the code. Kindly help on this please

private void button3_Click(object sender, EventArgs e)
        {
            SqlConnection dbconnect = new SqlConnection();
            string sql = null;
            
            dbconnect.ConnectionString = @"Data Source=JP-PC\SQLEXPRESS;Initial Catalog=FTSSCRIBETECH;Integrated Security=True;";
            try
            {
                dbconnect.Open();
                CrystalReport13 CR;
                CR = new CrystalReport13();
                sql = "SELECT 'TRUSTID','SUM(UPLOADLNCNT)' FROM DCLIVEJOBS GROUP BY TRUSTID";

                SqlDataAdapter sda = new SqlDataAdapter(sql, dbconnect);
                
                DataSet ds = new DataSet();
                sda.Fill(ds, "DataSet1");
                CR.SetDataSource(ds);
                
              

                crystalReportViewer1.ReportSource = CR;
                crystalReportViewer1.Refresh();


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