Providing manual data source for crystal reports

Hi Ashok,

On your form's button Click Event:

  private void btnReport_Click(object sender, EventArgs e)
        {
            try
            {             
                  
                   View_Reports("Select * from tblname where  manager_id='" +cmbName.Text+'", "rptEmp.rpt"");
                    Report.ShowDialog();
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

private void View_Reports(string Querry, string CRReportName)
{
                string reppath = "";
                con = oDAL.OpenConnection();
                SqlDataAdapter da1 = new SqlDataAdapter(Querry, con);
                DataSet ds = new DataSet();
                da1.Fill(ds);
                rd = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
              
     
                reppath =Application.Startuppath + "\\Reports\\" + CRReportName + "";
       
               
             
                rd.Load(reppath);
                rd.SetDataSource(ds.Tables[0]);
                crystalReportViewer1.ReportSource = rd;
                crystalReportViewer1.ShowCloseButton = true;
}

This may help you