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; }