private void metroButton2_Click(object sender, EventArgs e)
 {
     try
     {
         DailyReportContactLense rpt = new DailyReportContactLense();
         rpt.RecordSelectionFormula = "{receipt1.ReceiptDate} in Date(" + DateStartDate.Value.ToString("yyyy,MM,dd") + ") to Date(" + DateEndDate.Value.ToString("yyyy,MM,dd") + ") AND {contactlense1.Branch} = " + Session.BranchId + "AND {receipt1.OrderType} = 'LENSE'";
         new UI_REPORT_VIEWER(rpt).Show();
     }
     catch (Exception ex)
     {
         CommonFunctions.ShowError(this, ex.ToString());
         CommonFunctions.WriteToErrorLog(ex.ToString());
     }
 }
 private void BtnContactLenses_Click(object sender, EventArgs e)
 {
     try
     {
         fromYear  = DateDailyReport.Value.Year.ToString();
         fromMonth = DateDailyReport.Value.Month.ToString();
         fromDay   = DateDailyReport.Value.Day.ToString();
         DailyReportContactLense rpt = new DailyReportContactLense();
         //{receipt1.ReceiptDate} = {receipt1.Branch}{receipt1.OrderType}
         rpt.RecordSelectionFormula = "{receipt1.ReceiptDate} = DATE(" + fromYear + "," + fromMonth + "," + fromDay + ") AND {contactlense1.Branch} = " + Session.BranchId + "AND {receipt1.OrderType} = 'LENSE'";
         //CommonFunctions.ShowError(this,rpt.RecordSelectionFormula.ToString());
         new UI_REPORT_VIEWER(rpt).Show();
     }
     catch (Exception ex)
     {
         CommonFunctions.ShowError(this, ex.ToString());
         CommonFunctions.WriteToErrorLog(ex.ToString());
     }
 }