private void PrintDealerHistory(ReportViewer rptViewer)
{
String lsDealerNum = comboBoxDealer.Text.TrimEnd().TrimStart() + "%";
opnhdealTableAdapter.FillByDealerDateRange(iACDataSet.OPNHDEAL, lsDealerNum, (DateTime)nullableDateTimePickerStartDate.Value, (DateTime)nullableDateTimePickerEndDate.Value);
opndealrTableAdapter.CustomizeFill(@"SELECT * FROM OPNDEALR WHERE OPNDEALR_ACC_NO IN (SELECT DEALHIST_ACC_NO FROM OPNHDEAL WHERE DEALHIST_POST_DATE >= '" +
((DateTime)nullableDateTimePickerStartDate.Value).Year.ToString() + "-" +
((DateTime)nullableDateTimePickerStartDate.Value).Month.ToString() + "-" +
((DateTime)nullableDateTimePickerStartDate.Value).Day.ToString() + @"' AND DEALHIST_POST_DATE <= '" +
((DateTime)nullableDateTimePickerEndDate.Value).Year.ToString() + "-" +
((DateTime)nullableDateTimePickerEndDate.Value).Month.ToString() + "-" +
((DateTime)nullableDateTimePickerEndDate.Value).Day.ToString() + @"' AND DEALHIST_ACC_NO LIKE '" + lsDealerNum + @"')");
opndealrTableAdapter.CustomFillBy(iACDataSet.OPNDEALR);
if (iACDataSet.OPNHDEAL.Rows.Count == 0)
{
MessageBox.Show("*** Sorry there are no OPNHDEAL records for the DATES and/or DEALER you selected!!! ***");
}
else
{
OpenDealerHistory myReportObject = new OpenDealerHistory();
myReportObject.SetDataSource(iACDataSet);
myReportObject.SetParameterValue("gdFromDate", (DateTime)nullableDateTimePickerStartDate.Value);
myReportObject.SetParameterValue("gdToDate", (DateTime)nullableDateTimePickerEndDate.Value);
myReportObject.SetParameterValue("gsUserID", Program.gsUserID);
myReportObject.SetParameterValue("gsUserName", Program.gsUserName);
rptViewer.crystalReportViewer.ReportSource = myReportObject;
rptViewer.crystalReportViewer.Refresh();
rptViewer.Show();
}
}
public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() {
OpenDealerHistory rpt = new OpenDealerHistory();
rpt.Site = this.Site;
return rpt;
}
