public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { DueDateBorrowedCrystalReport rpt = new DueDateBorrowedCrystalReport(); rpt.Site = this.Site; return(rpt); }
private void CheckOutReminderViewPort_Load(object sender, EventArgs e) { DueDateBorrowedCrystalReport crpt1DueDate = new DueDateBorrowedCrystalReport(); String query = "SELECT * FROM dbo.current_lending as l INNER JOIN dbo.contacts AS b ON b.id = l.borrower_id INNER JOIN dbo.slides AS s ON s.id = l.slide_id INNER JOIN dbo.donors as d on d.id = s.donor_id inner join dbo.species_category as sc on sc.id = d.species_catgeroy_id inner join dbo.species_specifics as ss on ss.id = d.species_specific_id inner join dbo.density_category as dc on dc.id = d.density_category_id where DATEDIFF(day, due_date, GETDATE()) > 0 and s.isBorrowed = 1 and isDamaged = 0 and isOutExchanged = 0 and isMissing = 0 and s.isActive = 1 ORDER BY d.donor_code,s.created_date ASC;"; SqlDataAdapter dataAdapter = new SqlDataAdapter(query, DBConnectionSingltonServices.GetConnection()); dataAdapter.SelectCommand.CommandText = query; DataTable sqldatatable = new DataTable(); dataAdapter.Fill(sqldatatable); crpt1DueDate.Database.Tables["current_lending_duedate_passed"].SetDataSource(sqldatatable); CheckoutRemindercrystalReportViewer1.ReportSource = crpt1DueDate; }