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