Hello sir.
I want to search between Two dates in crystal report...but im not getting Proper output..my code is below....plz help me.....
protected void Page_Load(object sender, EventArgs e)
{
DataSet1 ds = new DataSet1();
DataSet1TableAdapters.job_tableTableAdapter da = new DataSet1TableAdapters.job_tableTableAdapter();
da.Fill(ds.job_table);
CrystalReportSource1.ReportDocument.SetDataSource(ds);
}
protected void CrystalReportViewer1_Init(object sender, EventArgs e)
{
}
protected void RadButton1_Click(object sender, EventArgs e)
{
DataSet1 ds = new DataSet1();
DataSet1TableAdapters.job_tableTableAdapter da = new DataSet1TableAdapters.job_tableTableAdapter();
da.Fill(ds.job_table);
CrystalReportSource1.ReportDocument.SetDataSource(ds);
if (RadDatePicker1.SelectedDate.HasValue && RadDatePicker2.SelectedDate.HasValue)
{
CrystalReportViewer1.SelectionFormula = "{job_table.date}>=#" + RadDatePicker1.SelectedDate.Value.ToShortDateString() + "# and {job_table.date}<=#" + RadDatePicker2.SelectedDate.Value.AddDays(0).ToShortDateString() + "#";
}
else if (RadDatePicker1.SelectedDate.HasValue)
{
CrystalReportViewer1.SelectionFormula = "{job_table.date}>=#" + RadDatePicker1.SelectedDate.Value.ToShortDateString() + "# and {job_table.date}<=#" + RadDatePicker1.SelectedDate.Value.AddDays(0).ToShortDateString() + "#";
}
else
{
}
}
}