سوال درباره کریستال ریپورت؟

[nava_2012]

سلام.من دو جدول به نام های sabt1 و , sabt 2 دارم.میخوام این دو رو جوین کنم و در گذارشم ازش استفاده کنم.
نمونه کدی که استفاده کردم:


private void aquaButton1_Click(object sender, EventArgs e)
{
CrystalReport4 cr = new CrystalReport4();
try
{
string a = maskedTextBox1.Text;
string b = maskedTextBox2.Text;
// DataSet3 ds1 = new DataSet3();


cn conn = new cn();


// string st = "select sabt1.shozviat ,sabt1.name ,sabt1.lname , sabt1.pname ,sabt1.datet ,sabt1.sh , sabt1.mahal , sabt1.codemeli ,sabt1.taahol , sabt1.tahsilat , sabt1.noee , sabt1.isargari , sabt1.phoneh , sabt2.noeozviat ,sabt2.dateozv ,sabt2.datetam ,sabt2.darajef from (sabt1 INNER JOIN sabt2 ON sabt1.shozviat=sabt2.shozviat) where sabt2.noeozviat= N'"+ comboBox1.Text +"' and sabt2.dateozv between '" + a + "' and '" + b + "'";
string st;

st = "SELECT sabt1.name, sabt1.lname, sabt1.pname, sabt1.datet, sabt1.sh, sabt1.mahal, sabt1.codemeli, sabt1.taahol, sabt1.tahsilat, sabt1.noee, sabt1.isargari, sabt1.phoneh, sabt1.shozviat, sabt2.noeozviat, sabt2.dateozv, sabt2.darajef FROM ( sabt1 INNER JOIN sabt2 ON sabt1.shozviat = sabt2.shozviat)";
//where sabt1.shozviat='" + System.Convert.ToInt32 (textBox1.Text) + "'";
// st = "select * from sabt1";
// st = "select * from sabt2";

SqlDataAdapter dr = new SqlDataAdapter(st,conn.cnn ());
DataSet2 ds11 = new DataSet2();

// DataSet1 ds1 = new DataSet1();
dr.Fill(ds11, "sabt2"+ "join on"+ "sabt1");
//dr.Fill(ds1, "sabt1");

// dataGridView1.DataBindings.Clear();
// dataGridView1.DataBindings.Add(new Binding("datasource", ds1, "sabt1"));




cr.SetDataSource(ds11);
// cr.SetDataSource(ds1);
crystalReportViewer1.ReportSource = cr;
// cr.SetParameterValue("a1", maskedTextBox1.Text);
// cr.SetParameterValue("a2", maskedTextBox2.Text);
// crystalReportViewer1.ReportSource = cr;
//// // RepDoc.DataDefinition.RecordSelectionFormula = "{reside.feres} ='" + comboBox4.Text + "'";
//// RepDoc.DataDefinition.RecordSelectionFormula = " ({sabt.date}IN " + "'" + maskedTextBox1.Text + "'to'" + maskedTextBox2.Text + "')";
// crystalReportViewer1.ReportSource = RepDoc;
//}
conn.cnnclose();
// if (maskedTextBox1.Text !="" && maskedTextBox2.Text !="" && comboBox1.Text !="" && comboBox2.Text == "" && comboBox3.Text =="")
// {


//}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}


}


این کد داده ها مو در کریستال ریپورت نشون نمیده.فقط یک ریپورت خالی نشون میده.
لطفا کمکم کنید.
باتشکر.

[nava_2012]

private void aquaButton1_Click(object sender, EventArgs e)
{
CrystalReport4 cr = new CrystalReport4();
try
{
string a = maskedTextBox1.Text;
string b = maskedTextBox2.Text;
// DataSet3 ds1 = new DataSet3();


cn conn = new cn();


// string st = "select sabt1.shozviat ,sabt1.name ,sabt1.lname , sabt1.pname ,sabt1.datet ,sabt1.sh , sabt1.mahal , sabt1.codemeli ,sabt1.taahol , sabt1.tahsilat , sabt1.noee , sabt1.isargari , sabt1.phoneh , sabt2.noeozviat ,sabt2.dateozv ,sabt2.datetam ,sabt2.darajef from (sabt1 INNER JOIN sabt2 ON sabt1.shozviat=sabt2.shozviat) where sabt2.noeozviat= N'"+ comboBox1.Text +"' and sabt2.dateozv between '" + a + "' and '" + b + "'";
string st;

st = "SELECT sabt1.name, sabt1.lname, sabt1.pname, sabt1.datet, sabt1.sh, sabt1.mahal, sabt1.codemeli, sabt1.taahol, sabt1.tahsilat, sabt1.noee, sabt1.isargari, sabt1.phoneh, sabt1.shozviat, sabt2.noeozviat, sabt2.dateozv, sabt2.darajef FROM ( sabt1 INNER JOIN sabt2 ON sabt1.shozviat = sabt2.shozviat)";
//where sabt1.shozviat='" + System.Convert.ToInt32 (textBox1.Text) + "'";
// st = "select * from sabt1";
// st = "select * from sabt2";

SqlDataAdapter dr = new SqlDataAdapter(st,conn.cnn ());
DataSet2 ds11 = new DataSet2();

// DataSet1 ds1 = new DataSet1();
dr.Fill(ds11, "sabt2"+ "join on"+ "sabt1");
//dr.Fill(ds1, "sabt1");

// dataGridView1.DataBindings.Clear();
// dataGridView1.DataBindings.Add(new Binding("datasource", ds1, "sabt1"));




cr.SetDataSource(ds11);
// cr.SetDataSource(ds1);
crystalReportViewer1.ReportSource = cr;
// cr.SetParameterValue("a1", maskedTextBox1.Text);
// cr.SetParameterValue("a2", maskedTextBox2.Text);
// crystalReportViewer1.ReportSource = cr;
//// // RepDoc.DataDefinition.RecordSelectionFormula = "{reside.feres} ='" + comboBox4.Text + "'";
//// RepDoc.DataDefinition.RecordSelectionFormula = " ({sabt.date}IN " + "'" + maskedTextBox1.Text + "'to'" + maskedTextBox2.Text + "')";
// crystalReportViewer1.ReportSource = RepDoc;
//}
conn.cnnclose();
// if (maskedTextBox1.Text !="" && maskedTextBox2.Text !="" && comboBox1.Text !="" && comboBox2.Text == "" && comboBox3.Text =="")
// {


//}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}


}

[nava_2012]

private void aquaButton1_Click(object sender, EventArgs e)
{
CrystalReport4 cr = new CrystalReport4();
try
{
string a = maskedTextBox1.Text;
string b = maskedTextBox2.Text;
// DataSet3 ds1 = new DataSet3();


cn conn = new cn();


// string st = "select sabt1.shozviat ,sabt1.name ,sabt1.lname , sabt1.pname ,sabt1.datet ,sabt1.sh , sabt1.mahal , sabt1.codemeli ,sabt1.taahol , sabt1.tahsilat , sabt1.noee , sabt1.isargari , sabt1.phoneh , sabt2.noeozviat ,sabt2.dateozv ,sabt2.datetam ,sabt2.darajef from (sabt1 INNER JOIN sabt2 ON sabt1.shozviat=sabt2.shozviat) where sabt2.noeozviat= N'"+ comboBox1.Text +"' and sabt2.dateozv between '" + a + "' and '" + b + "'";
string st;

st = "SELECT sabt1.name, sabt1.lname, sabt1.pname, sabt1.datet, sabt1.sh, sabt1.mahal, sabt1.codemeli, sabt1.taahol, sabt1.tahsilat, sabt1.noee, sabt1.isargari, sabt1.phoneh, sabt1.shozviat, sabt2.noeozviat, sabt2.dateozv, sabt2.darajef FROM ( sabt1 INNER JOIN sabt2 ON sabt1.shozviat = sabt2.shozviat)";
//where sabt1.shozviat='" + System.Convert.ToInt32 (textBox1.Text) + "'";
// st = "select * from sabt1";
// st = "select * from sabt2";

SqlDataAdapter dr = new SqlDataAdapter(st,conn.cnn ());
DataSet2 ds11 = new DataSet2();

// DataSet1 ds1 = new DataSet1();
dr.Fill(ds11, "sabt2"+ "join on"+ "sabt1");
//dr.Fill(ds1, "sabt1");

// dataGridView1.DataBindings.Clear();
// dataGridView1.DataBindings.Add(new Binding("datasource", ds1, "sabt1"));




cr.SetDataSource(ds11);
// cr.SetDataSource(ds1);
crystalReportViewer1.ReportSource = cr;
// cr.SetParameterValue("a1", maskedTextBox1.Text);
// cr.SetParameterValue("a2", maskedTextBox2.Text);
// crystalReportViewer1.ReportSource = cr;
//// // RepDoc.DataDefinition.RecordSelectionFormula = "{reside.feres} ='" + comboBox4.Text + "'";
//// RepDoc.DataDefinition.RecordSelectionFormula = " ({sabt.date}IN " + "'" + maskedTextBox1.Text + "'to'" + maskedTextBox2.Text + "')";
// crystalReportViewer1.ReportSource = RepDoc;
//}
conn.cnnclose();
// if (maskedTextBox1.Text !="" && maskedTextBox2.Text !="" && comboBox1.Text !="" && comboBox2.Text == "" && comboBox3.Text =="")
// {


//}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}


}

[nava_2012]

لطفا کمک کنید.

[Mahmoud Zaad]

سلام
اینجا (http://barnamenevis.org/showthread.php?363108-%DA%AF%D8%B2%D8%A7%D8%B1%D8%B4-%DA%AF%DB%8C%D8%B1%DB%8C-%D8%A7%D8%B2-%DA%86%D9%86%D8%AF-%D8%AA%D8%A7-%D8%AC%D8%AF%D9%88%D9%84-%D8%A8%D8%A7-view-%D9%88-%DA%A9%D8%B1%DB%8C%D8%B3%D8%AA%D8%A7%D9%84-%D8%9F&highlight=%DA%AF%D8%B2%D8%A7%D8%B1%D8%B4) رو ببینید.