public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { CrystalReportAllComingExchageSlides rpt = new CrystalReportAllComingExchageSlides(); rpt.Site = this.Site; return(rpt); }
private void AllGoingExchangeSlidesReportViewPort_Load(object sender, EventArgs e) { try { String query = "SELECT * from exchanges c inner join slides as s on s.id = c.slide_id inner join donors as d on d.id = s.donor_id inner join borrowers as b on b.id = c.exchange_contact_id inner join species_specifics as ss on ss.id = d.species_specific_id inner join species_category as sc on sc.id = d.species_catgeroy_id inner join species_stages as st on st.id = d.species_stage_id inner join density_category as dc on dc.id = d.density_category_id order by exchanged_date desc;"; SqlDataAdapter dataAdapter = new SqlDataAdapter(query, DBConnectionSingltonServices.GetConnection()); dataAdapter.SelectCommand.CommandText = query; DataTable sqldatatable = new DataTable(); dataAdapter.Fill(sqldatatable); CrystalReportAllComingExchageSlides crystalReportExchangeCheckout = new CrystalReportAllComingExchageSlides(); crystalReportExchangeCheckout.Database.Tables["ExchangeCheckouReportTable"].SetDataSource(sqldatatable); crystalReportViewer1.ReportSource = crystalReportExchangeCheckout; } catch (Exception ex) { logger.Error(ex, "Checkout Report generation has some expections"); } }