public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { CrystalReportAllSlides rpt = new CrystalReportAllSlides(); rpt.Site = this.Site; return(rpt); }
private void AllSlidesReportViewePort_Load(object sender, EventArgs e) { String query = "SELECT s.id, s.bar_code, s.sequence, s.donor_id, s.cabinet_number, s.drawer_number, s.box_number, s.isDamaged, s.isReserved, s.isBorrowed, s.isActive, s.updated_date, s.created_date, s.created_by, s.updated_by, d.id AS donor_donor_id, d.donor_code, d.species_specific_id, d.species_stage_id, d.species_catgeroy_id, d.lower_density, d.average_density, d.upper_density, d.density_category_id, d.owner_id, d.acquired_date, d.country_code, d.comment, d.validation_id FROM dbo.slides AS s INNER JOIN dbo.donors AS d ON d.id = s.donor_id ORDER BY s.created_date DESC"; SqlDataAdapter dataAdapter = new SqlDataAdapter(query, DBConnectionSingltonServices.GetConnection()); dataAdapter.SelectCommand.CommandText = query; DataTable sqldatatable = new DataTable(); dataAdapter.Fill(sqldatatable); CrystalReportAllSlides crpt1AllSlides = new CrystalReportAllSlides(); crpt1AllSlides.Database.Tables["recent_slide_dataset"].SetDataSource(sqldatatable); crystalReportViewer1.ReportSource = crpt1AllSlides; }