private void btnPreview_Click(object sender, EventArgs e) { try { string vWhere = string.Empty; string criteria = string.Empty; Reports.RptReportViewer vForm = new Reports.RptReportViewer(); if (!string.IsNullOrEmpty(this.txt_ProductID.Text)) { vWhere += " AND StockWastageBody.ProductID=" + this.txt_ProductID.Text; } if (optRange.Checked == true) { vWhere += " AND convert(datetime,Convert(varchar,StockWastage.EntryDate,1)) Between Convert(Datetime,(convert(varchar,convert(Datetime,'" + this.dt_From.Text + " 00:00:00',102),1))) AND Convert(Datetime,(convert(varchar,convert(Datetime,'" + this.dt_ToDate.Text + " 00:00:00',102),1)))"; criteria += "From: " + dt_From.Value.ToString("dd-MMM-yyyy") + " To: " + dt_ToDate.Value.ToString("dd-MMM-yyyy"); } else { criteria += " Till Date: " + dt_ToDate.Value.ToString("dd-MMM-yyyy"); } DataTable dt = objDAL.getRecord(vWhere); if (dt.Rows.Count == 0) { MessageBox.Show("No Data To Display", "No Data"); return; } vForm.ProductWiseWaste(criteria, dt); vForm.ShowDialog(); } catch (Exception exc) { MessageBox.Show(exc.Message, "Error"); } }